I have created a database in Excel for a client to do data entry.
Right now I have multiple forms set up that they can scroll through
and enter data about different programs. Then at the end they are
prompted to save the record, which runs code to copy all of the data
on the forms to a hidden worksheet.

I need to be able to build in the functionality to allow the user to
save a record half way through completing, and then be able to re-load
the data at a later time, edit it, and their changes would be saved
over the original record.

Unfortunately, creating this database in Access is not an option.
But, that's basically what I need to do - make the Excel forms behave
like Access in that you can scroll through records, edit them, and
changes are saved.

I have been scouring the Internet for examples or information on how
to do this, but haven't come up with any answers. Does anyone have
any insight? I would really appreciate it.

Thanks.