Report

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

Ask a question sand3045 - Last answered on Apr 19, 2017 at 04:20 PM by ac3mark
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 
Helpful
+0
plus moins
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!

Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!