Merging to excel

[Dave]

hi,

is it possible to merge information into excel in the same
way you can in ms word

cheers
dave

 

[Bernard V Liengme]

To combine test into one cell use: A1&B1&C1 etc or if spaces are needed A1&"
"&B1&" "&C1
To convert the results to values use Edit followed by Paste Special/Values
Select all the cell with formulas, click the Copy tool, immediately open the
Edit menu, locate PasteSpecial and check the Value box.
Bernard

 

[Bernard V Liengme]

Or did you mean taking data from more that one Sheet?
=[Book2.xls]Sheet1!$A$1

Bernard

 

[Dave]

sorry, i think my post was slightly vague

i meant a mail merge, as in i have info in a database and
would like to produce a form based in an excel sheet which
is then printable for all records which appear in the
database, ie name, address etc

apologies

dave

-----Original Message-----
Or did you mean taking data from more that one Sheet?
=[Book2.xls]Sheet1!$A$1

Bernard

hi,

is it possible to merge information into excel in the same
way you can in ms word

cheers
dave

.

 

[Dave Peterson]

You could build a macro that would take the imported data and populate a
worksheet. Then print it, then advance to the next record, populate, print,
etc.

But it's not built into excel like it's built into Word.

sorry, i think my post was slightly vague

i meant a mail merge, as in i have info in a database and
would like to produce a form based in an excel sheet which
is then printable for all records which appear in the
database, ie name, address etc

apologies

dave

-----Original Message-----
Or did you mean taking data from more that one Sheet?
=[Book2.xls]Sheet1!$A$1

Bernard

hi,

is it possible to merge information into excel in the same
way you can in ms word

cheers
dave

.