ianb Member Dec 10, 2012 #1 Hi, Does any one have a macroprogram that I can set various pivot tables by name to todays date andor months e.g. Sheet1 pivottable 1 and 2 = todays date Sheet2 pivottable 3 and 4 = this month and pivotable 1 and 2 last month. Thanks.
Hi, Does any one have a macroprogram that I can set various pivot tables by name to todays date andor months e.g. Sheet1 pivottable 1 and 2 = todays date Sheet2 pivottable 3 and 4 = this month and pivotable 1 and 2 last month. Thanks.