Advanced excel help required to create a macro that creates new workbooks
Budget: $30 – $250 AUD
I have an original workbook containing 3 sheets (named sheet 1, 2 & 3). Sheet 2 contains data that needs to be cut based on specific words in column AO (ie for all rows relevant to word 'X' or 'Y' a new workbook is created). The new workbook needs to:
1) maintain all formatting of original workbook
2) copy sheet 1 and 3, such that the sequence of sheets of the new workbook remains (sheet 1, 2 & 3)
3) file name of the new workbook should match the word in column AO (ie name of file should be 'X' or 'Y' depending on the data)
4) new workbook should be saved in the same location as original workbook
1) maintain all formatting of original workbook
2) copy sheet 1 and 3, such that the sequence of sheets of the new workbook remains (sheet 1, 2 & 3)
3) file name of the new workbook should match the word in column AO (ie name of file should be 'X' or 'Y' depending on the data)
4) new workbook should be saved in the same location as original workbook