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