Hi Friends,
I need to develop macro for one of my day to day activity which involves pasting data from 14 different excel files in single excel file in 14 different sheets. Format of source and destination files name is same except date change.
Destination file is Xxx.ddmmyy.xlsx
Source files format is as below.
XXXXX_XXXXXXX_ddmmyyyy.xls
data in first sheet always of all 14 files. and worksheet name is same across all 14 files.
Always clear data in destination sheets and paste updated data. There is one to one co-relation between which file to go in which sheet however worksheet name in destination file can be changed if required.
Warm regards,
Tumbad
I need to develop macro for one of my day to day activity which involves pasting data from 14 different excel files in single excel file in 14 different sheets. Format of source and destination files name is same except date change.
Destination file is Xxx.ddmmyy.xlsx
Source files format is as below.
XXXXX_XXXXXXX_ddmmyyyy.xls
data in first sheet always of all 14 files. and worksheet name is same across all 14 files.
Always clear data in destination sheets and paste updated data. There is one to one co-relation between which file to go in which sheet however worksheet name in destination file can be changed if required.
Warm regards,
Tumbad