VBA to update excel dbase based on data in columns with latest dates in another workbook.

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.

Okay,

I attached sample of the currentdb and sourcedata.

currentdb.xlsx

samplesourcedata.xlsx

The thing I need is a dynamic macro to check for all dates in the header of each column in "sourcedata", and to copy only the ones not already in the "currentdb", then columnd is then pasted right next to the last column in "currentdb".