View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lcoreilly lcoreilly is offline
external usenet poster
 
Posts: 11
Default Multiple Forms for Data Entry; re-loading data

Hi All,
I have 15 forms set up to enter data in Excel which then gets stored
in a hidden worksheet in the workbook.

Right now it is set up so that the user can scroll through all 15
forms, enter the data, and then they are prompted to save to the
database, which copies all the data over and erases the forms.

I think it will be useful to allow them to re-load the data they've
already entered, in case they need to make changes. So I'm imagining
some kind of drop box or something that will display all the IDs
associated with the information they've entered, and then they would
select one and the data would load, then whatever changes they made
would be recopied to that row.

I'm hoping this is relatively simple to do.... what is the best way to
approach this?

Thanks in advance.