PDA

View Full Version : Solved: Pivot table



ndendrinos
12-29-2006, 03:49 AM
Hello to all,
Looked at pivot table for the first time yesterday and was able, using the recorder, to put together a report based on columns A & B and it's OK.
I fail to expand the range to A1:F8 and need help.
While a revised code from one of you is welcomed I would prefer to learn how to do this manually and could use detailed instructions.
Maybe I should also mention than in between every ABS there are 5 more columns that I could delete as i did here ... if there is a way not to delete these columns and still get the desired result that would be even better (but not essential)
Thank you

ndendrinos
12-29-2006, 04:18 AM
Solved by consolidating all the ABS columns first using ALe's solution in :
http://vbaexpress.com/forum/showthread.php?t=8528&highlight=merge+columns
then building a pivot table based on just two columns.