How do I use excel information for a second excel worksheet

P

plittle

I am trying to transfer excel worksheet information, also used as a merge for
a word document, into another excel worksheet then I will be adding
additional information to that second worksheet
 
R

robert111

in cell A1 of spreadsheet2 type =

then go to spreadsheet1 cell A1 and press return

spreadsheet 2 is now a copy of spreadsheet 1 after you have dragged the
formula down and across as required.

Add new info and get merging....
 
P

plittle

Thank your for the advise. I did what you said in the spreadsheets and it
worked great but I do not know how to merge them together. I am totally new
to Excel. Could you please explain the "add new info and get merging . . .
" comment.
 
P

plittle

Can you please explain the "add new info and get merging . . ." comment.
The cell A1 thing worked but now I do not know how to "merge". I have not
used Excel before so all this is new
 
R

robert111

your original question said you would be adding new info before doing
the mail merge
 
Top