Thread: [Solved] creating macro for biffurcation in sheets according to data.
View Single Post
 
Old 12-20-2010, 09:52 AM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
  
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default
Hi,
in the macro I sent you, all you have to do is to change the "Important parameters" to the following values:

FirstRow = 14
StateColumn = "AB"
DataSheet = "original"

When creating the pivot table, please mark the cells AB13:AB65535.
Then create the pivot table as explained above and just follow the previous instructions. The macro will take some time to run, but it worked when I tested it on your complete file.

Kind regards
Bjorn
Reply With Quote