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
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