T
TheYellowDart
Hey There!!
O.k. I have a Excel sheet that is grouped by 3 things (Year, State,
Type) in that order. This creates 4 numbers on the left hand side for
grouping with the + and - Symbol.
As there are hundreds of year, state, and type combination I am trying
to create macro to seperate each group into a tab. In effect I would
get a tab that would have this name
=Year & "_" & State & "_" & Type. In the Tab would be the data for that
group. So on and so on until there were no more groups.
Please see the attached sample testdata.zip. Using this sample the
first tab would be 1995_CA_Type1. The next would be 1995_AZ_Type2, the
next would be 1995_AZ_Type3. So on and so forth.
Thanks,
TheYellowDart
+-------------------------------------------------------------------+
|Filename: testdata.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4237 |
+-------------------------------------------------------------------+
O.k. I have a Excel sheet that is grouped by 3 things (Year, State,
Type) in that order. This creates 4 numbers on the left hand side for
grouping with the + and - Symbol.
As there are hundreds of year, state, and type combination I am trying
to create macro to seperate each group into a tab. In effect I would
get a tab that would have this name
=Year & "_" & State & "_" & Type. In the Tab would be the data for that
group. So on and so on until there were no more groups.
Please see the attached sample testdata.zip. Using this sample the
first tab would be 1995_CA_Type1. The next would be 1995_AZ_Type2, the
next would be 1995_AZ_Type3. So on and so forth.
Thanks,
TheYellowDart
+-------------------------------------------------------------------+
|Filename: testdata.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4237 |
+-------------------------------------------------------------------+