trentonirons
New Member
- Joined
- Mar 27, 2017
- Messages
- 17
Hi all!
Hope today is finding you well. I have a VBA question for you. I need a macro to do a couple of things:
1) Move all rows with unique values in Column A to their own sheets within the same workbook. (I.e all rows with the value "WE Region" in column A need to be moved to the WE Region sheet). If the new sheet name doesn't exist, it needs to be created.
2) Provide space for me to copy some simple formulas to create some high level analysis on each sheet (i.e SUM formulas based on a dynamic range, etc.)
3) Save all tabs as their own worksheets in the same folder as the master workbook.
Can anyone help me with this? I am very new to VBA
Hope today is finding you well. I have a VBA question for you. I need a macro to do a couple of things:
1) Move all rows with unique values in Column A to their own sheets within the same workbook. (I.e all rows with the value "WE Region" in column A need to be moved to the WE Region sheet). If the new sheet name doesn't exist, it needs to be created.
2) Provide space for me to copy some simple formulas to create some high level analysis on each sheet (i.e SUM formulas based on a dynamic range, etc.)
3) Save all tabs as their own worksheets in the same folder as the master workbook.
Can anyone help me with this? I am very new to VBA
