Dear Experts
Please help me in this task on manual time entry. I have attached the workbook of auto entry.
But I am in need to do
1. manual entry and
2. retrieve the same record to do correction if any and save them to the same record
It will be great help! Thank you
What you can do is the following:I also would recommend the use of Excel table for the Recorded data
- Add a lookup-formula in the cells on sheet New retrieving the values for ID from sheet Recorded data
- Write a worksheet_change event procedure which
- Updates the edited data for the employee in the Recorded data sheet
- Inserts the lookup-formula back into the edited cell
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks