Copy and paste from worksheet to another

[dondonordas]

Hi ExcelForum Members,

Please help me. I have worksheets:
w1:= "Sales and Inventory System"
w2:= "Sales Summary"

In w1, the user will encode the details of sales. If user clicked the botton "Record to Sales", the details of sales will be recorded at w2.

W2 is the record/log of sales.


Here's the sample of my code.

Please Login or Register  to view this content.

For a better view of my problem, i attached my files.


Thanks in advance!







Sales and Inventory System.xlsmSalesSummary.xlsx

[hudibyk]

You have 1 mistake in Your code:
You set the value lr from file SalesSummary.xlsx, because after open this file, it is active, and you don't specify in which file macro set the value to lr variable, so it makes it from active sheet in active workbook

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[dondonordas]

Thank you for your response hudibyk but would you help me to figure out the code that activate the lr function in worksheet where it should pick up the inputs? Thank in advance!

[dondonordas]

I tried to insert code within the loop to activate the worksheet where the inputs picks but then the result the same. What code should i includes?

Thank you in advance hudibyk!