Copying data to Dynamic Columns

[jmh1]

I have a daily report file, 11.01, 11.02, etc.

I have a monthly file, "Summary.xls"

Row 2 of "Summary" contains the date.

Everyday, I am manually copying info from the daily report to the summary report. I would like to develop a macro that can determine which date the data I am using, and find the column # from the "summary".

copy (b5:b6) from 11.01 and paste to (11.01 column, row x) in the summary sheet.

thanks!

 

[tactps]

it sounds like you could use a MATCH and INDEX formula to do this without the use of VBA.

Can you post your worksheets, and show the formula you are currently using.