As shown in the example I would like to know how to write VBA that will let me past daily information to my master sheet and then add it to the Daily Collection Sheet while saving the previous days additions, continuing down the columns.
As shown in the example I would like to know how to write VBA that will let me past daily information to my master sheet and then add it to the Daily Collection Sheet while saving the previous days additions, continuing down the columns.
How about just copypasting data onto the bottom of the Master Sheet, and after you make that an Autotable, you just feed that into a Pivot Table? See attached.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
This would work but there are about 500 line items in the real master file and this has to be done daily so I am hoping that VBA can save the manual part of the daily routine.
Thank you for the suggestion.
An autotable will automatically expand to include new data appended to the bottom of it, and if the PivotTable is defined from the autotable instead of a range, then all you gotta do is click the "update" button on the PT and it will be good.
I mean, if you're in a position where you're trying to automate a daily task, I'd be looking at this copypasta business first (external data connection maybe? IDK what the structure of the data you're pulling from is), and then once you've got the import automated, only then look at how you're generating a report.
Thank you, I think I will use your suggestions and see how it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks