Need help writing Excel macro when range changes
I'm trying to write a macro to create a pivot table, but I don't know how to
designate which cell range to include because it will change on a weekly basis. |
Need help writing Excel macro when range changes
Try Debra's page on using a dynamic data source:
http://www.contextures.com/xlPivot01.html Excel -- Pivot Tables -- Dynamic Data Source -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "AT" wrote: I'm trying to write a macro to create a pivot table, but I don't know how to designate which cell range to include because it will change on a weekly basis. |
All times are GMT +1. The time now is 06:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com