Very Complicated VBA Question

[trentonirons]

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

 

[Perpa]

Can anyone help me with this? I am very new to VBA

trentonirons,
Welcome to the Forum.
What you have requested has been requested previously and a search would have revealed as much...so I will just point you in the direction you need to follow:

Add Sheets if Required and Sort Data to Each Sheet
http://www.mrexcel.com/forum/excel-questions/862440-visual-basic-applications-sorting.html
The code at the above link is sorting by the list of names in column A on Sheet1, then copying the row and pasting it into another worksheet that is either:

1. created if that name does not exist in the same workbook
OR...
2. If the name does exist, it will be pasted into that existing worksheet.

That should get you going.
Perpa