I have a table "UserSheet" which allows users to use dropdown to trigger a timestamp. I would like a code that would copy table data and paste it to the bottom of another table "TimeStampedOutput". Purpose of this is to create a timestamp log of all entries from each update. Not sure if this is too complex of an ask......
Try this code:
Please Login or Register to view this content.
Bernie Deitrick
Excel MVP 2000-2010
How can I modify it so to run in from another workbook? So will need to reference to workbook, sheet and table to another sheet & table.
You would do it like this:
Please Login or Register to view this content.
I was trying to recreate your code in my actual workbooks but was unable to. Please see attached and let me know what I am doing wrong.
"UserSheet Workbook" is where original data is housed. "Compile Workbook" is where I want data pasted into. "VBA Mission Control" is the workbook I will be running the code from.
Thank you and my apologies......very new to VBA.
Last edited by JyothiGrace; 01-23-2023 at 09:03 AM.
This should work in VBA Mission Control..... Just one note - your workbook Compile Workbook.xlsm is actually named Compile "Woorkbook".xlsm, with an extra "o" I have removed the extra o in the code - not sure where the typo started - just make sure your workbook name does not have the extra o.
Please Login or Register to view this content.
Thank you Bernie! Your explanations are very clear and complete. Very helpful! I attempted to apply your codes (with a few modifications) to another series of workbooks that I will be managing for my company but ran into a Run-time error (Application-defined or object-defined error). I believe it may have something to do with the table properties.
Are you able to ID the error in my code? BTW.....my file paths are all correct.
Try this code:
Please Login or Register to view this content.
That worked perfectly. Thanks Bernie!
Last question.....
How can I modify to only copy rows based on a condition? In "Coaching Report - Copy.xlsm", say I only want to copy/paste rows if in column D (SC Name) values equal "Kendal Gholston"?
You can apply a filter to your table based on the value you want to show - copy will only copy the visible cells then. Or we can add that to the macro, but if your values change, then it is often easier to just include one manual step.
Let me see how it works. Can you please send the VBA still?
Try this VBA:
Please Login or Register to view this content.
It worked on the attached samples but I can't seem to duplicate it on my actual sheets. Thanks however Bernie!
I will close and open another post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks