Hi all, I have tried combining and modifying different codes posted previously in this forum but couldn't work out how to exactly tailor it to my requirement.
I understand that my requirement is quite complex - would appreciate if anyone can help with this:
I'm trying to append multiple tabs from multiple spreadsheets into one master spreadsheet (exact same tab names, the order doesn't matter).
- each source spreadsheets contains different names, however there's a pattern to it (starts with either P- or C-)
- each source spreadsheets contains three tabs (tab names are: Roster, Change, Booking) to be appended into master spreadsheet with the same tab names
- there are three different folders source for the spreadsheets :
C:\Users\Marco\Desktop\BookingReport\Team1
C:\Users\Marco\Desktop\BookingReport\Team2\Red
C:\Users\Marco\Desktop\BookingReport\Team2\Blue
Essentially, each tab from source spreadsheet contains differing number of datalines (sometimes none).
For each tabs, I'm trying to append (copy paste as value) datalines from columns A to E , row 3 onwards, only if there are data (e.g. A3:E5 if there are three lines of data, if cell A3 is blank, don't copy paste anything)
Additionally, I need to add a new column to each dataline containing the first 6 characters of the file name (e.g. if file name is 'P-1234 evening roster' then the new column would have 'P-1234' in it)
Thank you in advance - really appreciate any help.
I understand that my requirement is quite complex - would appreciate if anyone can help with this:
I'm trying to append multiple tabs from multiple spreadsheets into one master spreadsheet (exact same tab names, the order doesn't matter).
- each source spreadsheets contains different names, however there's a pattern to it (starts with either P- or C-)
- each source spreadsheets contains three tabs (tab names are: Roster, Change, Booking) to be appended into master spreadsheet with the same tab names
- there are three different folders source for the spreadsheets :
C:\Users\Marco\Desktop\BookingReport\Team1
C:\Users\Marco\Desktop\BookingReport\Team2\Red
C:\Users\Marco\Desktop\BookingReport\Team2\Blue
Essentially, each tab from source spreadsheet contains differing number of datalines (sometimes none).
For each tabs, I'm trying to append (copy paste as value) datalines from columns A to E , row 3 onwards, only if there are data (e.g. A3:E5 if there are three lines of data, if cell A3 is blank, don't copy paste anything)
Additionally, I need to add a new column to each dataline containing the first 6 characters of the file name (e.g. if file name is 'P-1234 evening roster' then the new column would have 'P-1234' in it)
Thank you in advance - really appreciate any help.