Excel: Filling a user form with yesterday's data
 

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

--
randallwilkin
-----------------------------------------------------------------------
randallwilkins's Profile: http://www.excelforum.com/member.php...fo&userid=3505
View this thread: http://www.excelforum.com/showthread.php?threadid=54798

Excel: Filling a user form with yesterday's data
 

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

Excel: Filling a user form with yesterday's data
 

Hi Randall,

For a more sophisicated alternative to the DataForm, see John Walkenbach's
Enhanced DataForm, which may be downloaded, free odf charge, at:

http://j-walk.com/ss/dataform/index.htm


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Randall,

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


---
Regards,
Norman