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

[Closed]
Report
-
 Blocked Profile -
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.

1 reply

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