select certain cells in pivot table

bobbydigital · Mar 11th, 2002, 03:40 AM

I have a pivot table created from data from a database in excel and i need to create a macro that will select just the cells containing data input in the present and/or last month. i cannot group the data as it is imported from an outside source. please help i have 3 weeks to hand in this project!

[ This Message was edited by: bobbydigital on 2002-03-11 02:41 ]

Dave Hawley · Mar 11th, 2002, 03:46 AM

Hi Bobbydigital

Why do you say you cannot group your data by dates just because it's imported. If you dates are imported as text you can convert then by copying a number 1 from any cell, select you dates then Pastespecial multiply. If there are numeric and you still cannot group them it is most likely because you Pivot Table data range includes blank cell in the date column. Use a dynamic range to overcome this:

http://www.ozgrid.com/Excel/DynamicRanges.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 03:40 AM	#1
bobbydigital New Member Join Date: Mar 2002 Posts: 1	I have a pivot table created from data from a database in excel and i need to create a macro that will select just the cells containing data input in the present and/or last month. i cannot group the data as it is imported from an outside source. please help i have 3 weeks to hand in this project! [ This Message was edited by: bobbydigital on 2002-03-11 02:41 ]

Mar 11th, 2002, 03:46 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Bobbydigital Why do you say you cannot group your data by dates just because it's imported. If you dates are imported as text you can convert then by copying a number 1 from any cell, select you dates then Pastespecial multiply. If there are numeric and you still cannot group them it is most likely because you Pivot Table data range includes blank cell in the date column. Use a dynamic range to overcome this: http://www.ozgrid.com/Excel/DynamicRanges.htm