Split Workbook in New Workbooks and Split Workbook into Worksheets

[gallen6945]

Hi,

I need macro which will split raw data into new workbooks by column Q (using the Column Q as the new workbook file name ie One, Two, Three etc) and then the data being split into different worksheets (ie A B C etc)

I have xxx out the data - the data will always run to column AD

Any help will be greatly appreciated.

Thank you.

Row Labels
Five
M
N
O
P
Q
R
Four
K
L
T
U
V
X
Y
Z
AA
One
A
B
C
D
E
F
G
Six
S
Three
J
Two
H
I
Grand Total