I have about 5 files with data in columns A through BU. All 5 files have different names but 'data' is in worksheet.
i need a VBA to consolidate the data thats re all different length but only keeping current title in the Master file called 'Master'
Trying to get a VBA code to:
1. Clear data from master file
2. Open each of the 5 files. (TASS, MUC, SAS etc) but common start is 'Underlying Bridge - '
3. copy columns row 2 to where ever the data goes to and then add additional from file 2,3,4 etc
3. paste data tab within master file.
Can this be done? Thanks in advance.
i need a VBA to consolidate the data thats re all different length but only keeping current title in the Master file called 'Master'
Trying to get a VBA code to:
1. Clear data from master file
2. Open each of the 5 files. (TASS, MUC, SAS etc) but common start is 'Underlying Bridge - '
3. copy columns row 2 to where ever the data goes to and then add additional from file 2,3,4 etc
3. paste data tab within master file.
Can this be done? Thanks in advance.