Send the link and the exact name of the macro you use
--
Regards Ron De Bruin
http://www.rondebruin.nl
"rjr" wrote in message .. .
I used test 4 and made sure I put the last col and last row in also. Unfortunately I have the headers but all the rows don't have
information all the way to the last col. It appears when the master opened up it took data from all my sheets?
Don't know enough about vb to give you an accurate desc there....
BOB
"Ron de Bruin" wrote in message ...
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.
Which example do you use ???
Do you go to this page
http://www.rondebruin.nl/copy1.htm
--
Regards Ron De Bruin
http://www.rondebruin.nl
"rjr" wrote in message ...
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