LinkBack URL
About LinkBacks
Capture.JPG
I am trying to create a macro that updates a pivot table and then groups the dates by month and year, but I am getting an error. How do I fix this so that '1/1/1900' is whatever date that is first in the pivot table?
Capture.JPG
I am trying to create a macro that updates a pivot table and then groups the dates by month and year, but I am getting an error. How do I fix this so that '1/1/1900' is whatever date that is first in the pivot table?
You will probably have to go "off pivot table" for this. Somewhere on the sheet do a MIN() function on the source data for the date of interest. Set this to a variable, say MinDate and then use the following code.
You might have to put a single quote around that (CHR(27)).
Please Login or Register to view this content.
If you don't want to go off table then consider Application.WorksheetFunction.MIN(Range_with_the_Date)Please Login or Register to view this content.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks