Split master worksheet by field value into separate workbooks
Budget: £20 – £250 GBP
Hello,
My scenario is: I have a master worksheet named Sheet1 inside the Test Macros workbook attached. There are other 2 worksheets in this workbook: Timesheet Template and Settings
My objective is to
1. Split Sheet1 from Test Macros by Resource name into separate workbooks and save them into another folder
2. Copy worksheet Timesheet Template to each of the separate workbooks newly created
3. This is the step where I got stuck: FORMULAS ON SHEET TIMESHEET TEMPLATE INSIDE EACH NEWLY CREATED WORKBOOK SHOULD LOSE THE REFERENCE TO THE MASTER SHEET AND TAKE THE REFERENCE FROM SHEET1 INSIDE NEW WORKBOOK (BASICALLY TRIED TO COPY FORMULAS AS TEXT)
Inside the Test Macros workbook, there is a Settings worksheet with 2 buttons that run 2 codes I created. First code is working fine. The issue is that the second code does not copy all the formulas correctly. The formulas in cells F4:F11, F12:F18, U4 and V4 on the Timesheet Template sheet contain some additional "@" characters that are not on the original Timesheet Template sheet inside Test Macros and that leads to formulas not working anymore
I would need an expert to have a look at the second code please
I am also attaching the 3 result files after running the 2 macros
I am due to sort this out and have it ready on Monday morning
Thank you so much in advance for your help with this
My scenario is: I have a master worksheet named Sheet1 inside the Test Macros workbook attached. There are other 2 worksheets in this workbook: Timesheet Template and Settings
My objective is to
1. Split Sheet1 from Test Macros by Resource name into separate workbooks and save them into another folder
2. Copy worksheet Timesheet Template to each of the separate workbooks newly created
3. This is the step where I got stuck: FORMULAS ON SHEET TIMESHEET TEMPLATE INSIDE EACH NEWLY CREATED WORKBOOK SHOULD LOSE THE REFERENCE TO THE MASTER SHEET AND TAKE THE REFERENCE FROM SHEET1 INSIDE NEW WORKBOOK (BASICALLY TRIED TO COPY FORMULAS AS TEXT)
Inside the Test Macros workbook, there is a Settings worksheet with 2 buttons that run 2 codes I created. First code is working fine. The issue is that the second code does not copy all the formulas correctly. The formulas in cells F4:F11, F12:F18, U4 and V4 on the Timesheet Template sheet contain some additional "@" characters that are not on the original Timesheet Template sheet inside Test Macros and that leads to formulas not working anymore
I would need an expert to have a look at the second code please
I am also attaching the 3 result files after running the 2 macros
I am due to sort this out and have it ready on Monday morning
Thank you so much in advance for your help with this