Tags: blanks, cells, create, creates, excel, filter, goback, hide, hidesall, hii, ideas, macro, microsoft, msdn, pivot, records, software, table, tables, vba
vba pivot tables and hide blank cells
i need to create a vba macro which creates a pivot table and also hides
all blanks. Any ideas? I am still trying to filter out records which go
back to 1996, only keeping the 2004 records.
Message posted from http://www.mcse.ms/
Leave a comment...
- 1 Comments
- Post this question in the "microsoft.public.excel.charting" newsgroup. Debra
D. hangs out there and she's a wiz with pivot table :-)
Excel 2002 in Windows XP
"rbekka33 >" <<rbekka33.1cj0v4.excel.questionfor.info.excelforum-nospam.com> wrote in message
> i need to create a vba macro which creates a pivot table and also hides
> all blanks. Any ideas? I am still trying to filter out records which go
> back to 1996, only keeping the 2004 records.
> Message posted from http://www.mcse.ms/
>#1; Wed, 28 May 2008 22:48:00 GMT