Hi Randall,

Consider using Excel's built in DataForm which would appear to offer the
requested functionality.


---
Regards,
Norman



"randallwilkins"
wrote in
message news:randallwilkins.28sllg_1149281612.042@excelfor um-nospam.com...

I have an input form which the user fills out each day. They pick a
wellname from a list. I want to go to a worksheet and look for that
wellname. Once found, pull all the data in that row and populate that
user form in the proper fields. This gives them yesterday's data.
They will tab between fields and make changes if needed. I want them
to then save the data and have it write over yesterday's data on the
worksheet so that each day they pick a well, yesterday's data is
displayed. How do I do that?


--
randallwilkins
------------------------------------------------------------------------
randallwilkins's Profile:
http://www.excelforum.com/member.php...o&userid=35054
View this thread: http://www.excelforum.com/showthread...hreadid=547983