winxmun
04-10-2008, 07:45 PM
Hi there,
i am very new in excel macro but need to check how to update a cell from one worksheet to another worksheet.
example: To set macro at Worksheet A to allow user update certain fields & auto update to Worksheet B. Worksheet B will capture all records & disabled to user. how it function:
Step 1: User input the Account No. 1st & click on "Search" button. Excel to extract Customer Name (text box), Age (text box), date (text box) & Maker Name (droplist) from Worksheet B & display in Worksheet A.
Step 2: User to update the necessary.
Step 3: Click on "Update" button, excel to auto update the data into Worksheet B based on Account No.
Note: User must click on "Update" before exit the Excel file or input the new Account No.
Tks & Regards.
i am very new in excel macro but need to check how to update a cell from one worksheet to another worksheet.
example: To set macro at Worksheet A to allow user update certain fields & auto update to Worksheet B. Worksheet B will capture all records & disabled to user. how it function:
Step 1: User input the Account No. 1st & click on "Search" button. Excel to extract Customer Name (text box), Age (text box), date (text box) & Maker Name (droplist) from Worksheet B & display in Worksheet A.
Step 2: User to update the necessary.
Step 3: Click on "Update" button, excel to auto update the data into Worksheet B based on Account No.
Note: User must click on "Update" before exit the Excel file or input the new Account No.
Tks & Regards.