Thread: A Macro to UPDATE worksheet in database

Hi All

I'm very much a newbie with VBA. I need help with a project that I am currently trying to complete.

I made a database on excel with a Save command button and a Clear command button. To SAVE would be - to save the encoded data on sheet 1 and consolidate the said data on sheet 2, which is my Summary Sheet (where all the encoded data are consolidated horizontally). And of course, CLEAR - would clear the form.

I would like to add another command button. An UPDATE button.

In a column you have specific data being asked for that the user would need to fill out.

For example:

Name
Home Address
Phone Number
Occupation
Work Address

Now, since some information are still unknown, you would, in the future need to go back and fill it out. Instead of me, going through the Summary Sheet, I would like to be able to update specific data under a specific Name or heading (as given in the example above).

Now that's my dilemma. Could someone PLEAASSEEE help a out?

Thanks in advance!