LinkBack URL
About LinkBacks
I have a NewData table that changes every week. I am looking for a VBA code that would copy all data from this table and paste to bottom of Master_List table. And of course the Master_List table should resize to new data. Thank you
I have a NewData table that changes every week. I am looking for a VBA code that would copy all data from this table and paste to bottom of Master_List table. And of course the Master_List table should resize to new data. Thank you
Last edited by KerahJoy; 09-19-2024 at 10:15 PM. Reason: Upload Attachment
Try this
BSB
Please Login or Register to view this content.
Or
Please Login or Register to view this content.
How to modify your code to resize Master_List table to hold new data?
It is doing that in both suggested codes
The table should resize automatically, but I have experienced this not working for some users in applications I've built in the past.
Adding the part in red below should remedy that if it's happening for you.
Similar could be done with JEC's code.Please Login or Register to view this content.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks