Really great stuff there and I might need a little tweaking.
A little more detail.
I have 35 sheets in my workbook. 30 of them calculate amortizations for data
entered on the "Data Entry Sheet" and are printed seperately and they work
fine. This same "Data Entry Sheet" is used to provide information in each
field of the worksheet "Merge Data".
The "Merge Data" sheet is used as the data source for a mail merge into
WORD.
My delima is that with this setup I can only use one workbook at a time for
each merged document, as there is no way to have the sheet "Merge Data"
capture more than one row at a time.

I tried using your examples and they all go to "all sheets" instead of being
able to select just one sheet and pasting the information into the "Master"
worksheet.

How can I get the macro to go only to the 'Merge Data" sheet and take that
one row of information and paste that into the "Master" worksheet but allow
the Master to continue to have record one, record two, record three etc
continually pasted to them so after using 15 complete entries I can have 15
rows with the information and select which row I want to use for mail merge.

Hope this is clear. Worksheet can be made avail offline if necessary.

Thanks so much
Bob Reynolds
"Ron de Bruin" wrote in message
...
Hi rjr

Start here
http://www.rondebruin.nl/copy1.htm

Post back if you need more help

--
Regards Ron De Bruin
http://www.rondebruin.nl



"rjr" wrote in message
. ..
Hi,
I have one sheet of excel used to enter data into cells arranged as an
input form. All these entries are transferred to a second sheet that I
use as a merge file for a couple of WORD documents. Right now it
functions as a single entry database that is only good for one data
record.

I'm looking for a way to
1. Take all data from this worsheet tab and save it into the next
available row on my database. Eventually I need to add row 2 row 3 row 4
and so on, and this could be the information source for my flat database.

2. Be able to go to a specific record on the database sheet and alter the
data to permanently change it.

Basically I would like to have a macro to SAVE - NEXT - PREVIOUS - PRIOR
the database portion consists of about 75 columns for each record.

Any help would be appreciated if this is possible.

Hope someone has some code or a solution.
Thank you
Bob Reynolds