Excel as a Database and entering multiple records

  • Thread starter Thread starter Bob Reynolds
  • Start date Start date
B

Bob Reynolds

I have an excel workbook that uses 1 "Merge Data" sheet as a source for
multiple calculations throughout the workbook and also as a mail merge data
source.
My question is I have one worksheet that all the data is entered onto, but I
have a need to do the following:
1. have the ability to put buttons on the "Data Entry" sheet to allow me to
"add new record", "select record #", "Back one record", "Forward one record"
and the usual "Beginning" and "End".

by using these selections I could enter new information, update current or
select any particular record I wanted.

Any help would be appreciated. Thank you
 
I've thought of using those but it really isn't applicable to my problem. I
already have my data entry screen, which is my user form for entry of data.
This information on the sheet is linked to my merge form that actually
merges the information. I have to have this particular data entry
sheet/screen because of many variables.
I need to know how to insert the ability to select data 1, data 2 and so on.
Right now I can only use data for one entry and not open it for more than
one.

Access uses the next previous last first and I guess this is what I'm asking
is how to put the code into a macro or vb to make this data entry form do
it.
thanks
BOB
 
Back
Top