imported_unknown
Active Member
- Joined
- Jan 13, 2002
- Messages
- 424
I receive several excel files under different names but same date (XXX mm/dd/yy). Each of them has the same description on the rows of the first column. It's only from the second column onwards that it contains different data.
I would love to have a macro to automatically trigger actions when files are received. It checks whether the files are of the same date, opens the first file, save as same date, opens the second file that has the same date,copy the second columns onwards and paste into the first file sequentially. The macro will also check whether all the files are opened and copied into the new file.
How should I write the marco? Thanks
I would love to have a macro to automatically trigger actions when files are received. It checks whether the files are of the same date, opens the first file, save as same date, opens the second file that has the same date,copy the second columns onwards and paste into the first file sequentially. The macro will also check whether all the files are opened and copied into the new file.
How should I write the marco? Thanks
