Hi everyone,

I have a simple excel database that grows everyday. Ive gotten a macro form this forum that helps me copy columns based on headers which are dates.

The Issue is that want to create a macro that copies columns of the latest dates from another workbook; we shall call it "sourcedata" into my current database without manually entering the dates.

So suppose in my current excel database I have columns dated 23 may, 24 may and 25 may, the new macro will automatically find the column with the latest date header in the "sourcedata" workbook and copy the whole column and paste into the next empty column after the 25th may column in my current DB.

Please help out.