Need macro to copy certain data from a form on one tab to a log [Closed]

sand3045 - Apr 19, 2017 at 04:17 PM - Latest reply: ac3mark 9588 Posts Monday June 3, 2013Registration dateModeratorStatus June 21, 2018 Last seen
- Apr 19, 2017 at 04:20 PM
Hello,



Trying to copy data from a form on one tab to a log/data list on another tab and advance to the next line on the log for the next user to update the form and re-run the macro, and then save.
See more 

1 reply

ac3mark 9588 Posts Monday June 3, 2013Registration dateModeratorStatus June 21, 2018 Last seen - Updated by ac3mark on 19/04/17 at 04:29 PM
0
Thank you
Ok, so where are you stuck? Post back some code, and we can help.


Here is a portion of he solution:

TheStuffToCopy = thisworkbook.worksheets("tabwithform'').Range("A1:B99")
thisworkbook.worksheets("theheettocopyt'').Range(''A1:B99").value = TheStuffToCopy

Now you just need to count the rows (access would insert this automattically into a table for you!)

Why don't you use an Access DB and a form? Much less code!

It's kind of fun to do the impossible! -Walter Elias Disney