Dear experts
I have N number of workbooks in target folder in that sheet Pro! contains pivottable4 which range of data source not reset from old data range i want reset old data range to new data range of data sheetRPT25!...
like if Old Datasource A1:4500 i want to change through vba as A1 till end data end.
Path is D:\Mac\Forum\4-2-2016
pls find the attachment
If I understand you correctly, if you add more data beyond row 4500 you want the spreadsheet to acknowledge it.
If this is your requirement, change the range on _RPT25 to an Excel Table and then make the table your data source. Tables know exactly how many rows they have and any pivot table or formula that addresses them does not have to be changed when the range of the data changes.
See this article on Excel Tables: http://www.utteraccess.com/wiki/inde...ables_in_Excel
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks