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

sand3045 - Apr 19, 2017 at 04:17 PM
 Blocked Profile - Apr 19, 2017 at 04:20 PM

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.

1 response

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