Updating & keeping
 

I’ve got people coming to me and giving information. I record the
details of their information on a worksheet. I start by typing in
their reference number, then name and 3 address lines, 5 cells in
all. There’s another cell where I type the text of their information
- but that's not important here. I then print the sheet (because they
have to sign it) then clear all the cells where I’ve typed something
in, ready for the next person (got a macro for that already!) I’d
like to be able, if that person comes again, to type ONLY their
reference number in and get the name and address cells to populate
themselves, ie I want the worksheet to ‘remember’ all the person’s
details AND, if, say, they come for the first time and I type
everything in, then they come a 2nd time and tell me they’ve got
married and changed their name and or moved house and I overtype their
old name and or address with their new address, I’d like the worksheet
to discard their original name and or address details and ‘remember’
their latest details with their reference number. Hope I’ve explained
that right.

Updating & keeping
 

You could have a macro that moves the data to a database on another sheet.
Then, a macro that if you put in (several ways to do that) then the form is
re-populated with the info in the database. Change as desired and fire the
savetodatabase macro.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
I’ve got people coming to me and giving information. I record the
details of their information on a worksheet. I start by typing in
their reference number, then name and 3 address lines, 5 cells in
all. There’s another cell where I type the text of their information
- but that's not important here. I then print the sheet (because they
have to sign it) then clear all the cells where I’ve typed something
in, ready for the next person (got a macro for that already!) I’d
like to be able, if that person comes again, to type ONLY their
reference number in and get the name and address cells to populate
themselves, ie I want the worksheet to ‘remember’ all the person’s
details AND, if, say, they come for the first time and I type
everything in, then they come a 2nd time and tell me they’ve got
married and changed their name and or moved house and I overtype their
old name and or address with their new address, I’d like the worksheet
to discard their original name and or address details and ‘remember’
their latest details with their reference number. Hope I’ve explained
that right.