Excel: Filling a user form with yesterday's data

[randallwilkins]

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

 

[Norman Jones]

Hi Randall,

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


---
Regards,
Norman



"randallwilkins"

 

[Norman Jones]

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