Hi All,
I am a newbie here and would really appreciate your help on this. I used to do a lot of reports where I would dump a whole data dump on sheet 2 and then have a template on Sheet 1 that is all formatted and clean and attractive looking that would pull the data from the second sheet.
Basically, if the header on Sheet 1 appears on Sheet 2 then copy the entire column of data to the first tab. Out of 50 columns of data on Sheet 2 I want to return only the 10 columns that I need for the final report.
I cant for the life of me remember the formula I used and I have been looking around on the forum and cant seem to find it here either. Perhaps its because I don't know where to look...
Please help!
Les
Welcome to the Forum!
Attached is one idea. This looks up data in the second sheet based on the column heading in the first. A drawback of this is that the formatting is not mirrored. That is, you can see in my example that the Address looks fine but if you change the heading to Date, the referenced data is not formatted as dates. Also, referenced cells with no data are shown as zeroes; this could be fixed by wrapping an IF condition around the formula.
A more elegant (but much more work) solution that would handle the formatting issue automatically would be to use VBA to do the same thing.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks