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

Hi Bob

maybe the build-in Excel functionality will do: Goto 'Data - Input
mask..' Or try the following free add-in:
http://j-walk.com/ss/dataform/

HTH
Frank

Bob Reynolds wrote:
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

Maybe this would be useful. Thanks to J-Walk for a great addin.

http://www.j-walk.com/ss/dataform/index.ht

--
Message posted from http://www.ExcelForum.com

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
"Andrew " wrote in message
...
Maybe this would be useful. Thanks to J-Walk for a great addin.

http://www.j-walk.com/ss/dataform/index.htm


---
Message posted from http://www.ExcelForum.com/