santhoshlk
Board Regular
- Joined
- Feb 6, 2006
- Messages
- 206
Dear Friends.
Pls help me to develop my below macro.
I have a workbook with 2 sheets, say "Entry" and "List"
"Entry" sheet has the following cells B6 and D7.
What I need is a command button in Entry Sheet, once I enter any data in B6
and D7 and if I click the command button macro should copy the cell "Entry(B6)" and paste value in cell "List(A1)' also copy cell "Entry(D7)" and paste value in cell "List(B2)".
a msg box to be appear and say "Your entry has updated" and the sheet "Entry" to be active and cells are cleared for the next new entry.
IMPORTANT is whenever I update the entry by clicking the command, the data should be copied in sheet "List" in next row so I keep the entry records in that sheet.
Please help.
Thanks in advance. S
Pls help me to develop my below macro.
I have a workbook with 2 sheets, say "Entry" and "List"
"Entry" sheet has the following cells B6 and D7.
What I need is a command button in Entry Sheet, once I enter any data in B6
and D7 and if I click the command button macro should copy the cell "Entry(B6)" and paste value in cell "List(A1)' also copy cell "Entry(D7)" and paste value in cell "List(B2)".
a msg box to be appear and say "Your entry has updated" and the sheet "Entry" to be active and cells are cleared for the next new entry.
IMPORTANT is whenever I update the entry by clicking the command, the data should be copied in sheet "List" in next row so I keep the entry records in that sheet.
Please help.
Thanks in advance. S