Hi, what if I wanted to split only a single sheet of a workbook into multiple files based on two conditions? First condition, the sheet should be split even based on a variable value in a cell that is entered based on staff availability. The second condition looks at a specific column and after the split is made looks to see if there are duplicates appearing on two sheets. it will then delete certain rows from sheets and add them to other sheets to avoid any duplicates. Is this possible?
Hi, what if I wanted to split only a single sheet of a workbook into multiple files based on two conditions? First condition, the sheet should be split even based on a variable value in a cell that is entered based on staff availability. The second condition looks at a specific column and after the split is made looks to see if there are duplicates appearing on two sheets. it will then delete certain rows from sheets and add them to other sheets to avoid any duplicates. Is this possible?
How do you copy in the code?
Were you able to open the VBA editor?