Related:
- Need macro to copy certain data from a form on one tab to a log
- Transfer data from one excel worksheet to another automatically - Guide
- Www.instagram.com log in - Guide
- Wpan full form - Guide
- You've tried to log in too many times. to protect your account, a temporary block has been placed on logging in. please try again later. - Facebook Forum
- Facebook error - Facebook Forum
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
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
