I am trying to create a pivot table where the number of rows on the source data will be different daily. How can I make the source data dynamic so it adjusts with the number of rows that my spreadsheet has?
SourceData:="Accruals!R1C1:R4840C49"
I am trying to create a pivot table where the number of rows on the source data will be different daily. How can I make the source data dynamic so it adjusts with the number of rows that my spreadsheet has?
SourceData:="Accruals!R1C1:R4840C49"
Hi,
Create a dynamic range name that automatically adjusts to the length of your data. Define the name something like
Formula:Please Login or Register to view this content.
Then use the range name as the source name for your PT.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Or change the source data to an Excel table. http://www.utteraccess.com/wiki/Tables_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.
Here is what I have but it doesn't seem to like the formula in there.
Please Login or Register to view this content.
I got it working. Here is what I used:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks