ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Start Date And End Date with pivot tables? (https://www.excelbanter.com/excel-programming/385059-start-date-end-date-pivot-tables.html)

Mark J

Start Date And End Date with pivot tables?
 
how can i program thru vba a start and end date that will push these date
values into pivot table on code exececution?

Tom Ogilvy

Start Date And End Date with pivot tables?
 
use the find command to find the start and end dates.

Then copy the records between these two locations to a new worksheet with
the header information. Then use this as the source for your pivot table.

--
Regards,
Tom Ogilvy


"Mark J" wrote:

how can i program thru vba a start and end date that will push these date
values into pivot table on code exececution?



All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com