Hi everyone, need any help from forum guru's here.
Attached is the sample excel file with the code. MySampleDBs.xlsm
I use vba code in my attached sampledb that updates sheet "data" if there are newer data in sheets "new" according to the latest dates, basically it checks dates in sheet "data" and compares it with sheet "new", if there is newer dates in "new", it copies the whole column with the newer date and pastes it next to last used column in "data".
However the current code only adds a single column from the new ones, and loop copies only on that column instead of pasting to the next column after it.
I need the code to copy the latest dated column and loop until all new dated columns have been copied.
Please help out. Thanks.
Bookmarks