Hi guys,
I have the attached worksheet.
What i would like to do is, when I open the worksheet the find option to appear so as me to enter an ID to find.(ID column is the first column)
When it finds the ID, the cursor to move to Column D on the same line and to have a prompt asking me for a value to insert in that cell. Then to go to Column E and prompt me for a new value to be entered there.And the same with Column F.
When it finishes with Column F i need to be asked again to find the next ID on Column A and repeat the procedure.
If possible, after each 'procedure" (from Finding the ID to finishing on line F to ask whether I am finished searching for IDs)
In summary: 1. Find ID 2. Move to Column D on the same line and asked to enter a value 3.Move to Column E and asked to enter a value 4 Move to Column F on the same line and asked to enter a value
5. Ask if i am done entering values. 6 If NOT done then go to Step1. 6b. If done then save and close the file.
Thank you very much in advance guys!
TRV 2013-01.xlsx
Bookmarks