merge function from one spreadsheet to another

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I have a spreadsheet with names and addresses and another spreadsheet
that has to be sent to customers asking for various pieces of
information. I need to merge the address spreadsheet with the 2nd
spreadsheet in order to produce a copy for each customer. Is there a
function in Excel where I can do this? I've done merges with Word and
Excel many times but never using Excel as both the datasource and end
product. I'm using Excel 2003.
Thank you,
Pat
 
Pat,

Do you want an electronic copy, or a physical copy (a printout)?

HTH,
Bernie
MS Excel MVP
 
Pat,

Do you want an electronic copy, or a physical copy (a printout)?

HTH,
Bernie
MS Excel MVP






- Show quoted text -
Click to expand...

Bernie, right now I just want printed copies.
Pat
 
Pat,

You can use a macro to print out the pages.

Let's say that you have names and addresses on sheet "Data Sheet" in column A to C, starting in Row
2, and a worksheet named "Info Request" that you want to print out once for each set of
name/address. The names are placed in cell B4, and the address in B5, and the city state zip in B6
of "Info Request"

This macro will create the print outs:

Sub PrintEmAllOut()
Dim myC As Range

With Worksheets("Data Sheet")
For Each myC In .Range(.Range("A2"), .Cells(Rows.Count, 1).End(xlUp))
Worksheets("Info Request").Range("B4").Value = myC.Value
Worksheets("Info Request").Range("B5").Value = myC(1, 2).Value
Worksheets("Info Request").Range("B6").Value = myC(1, 3).Value
Worksheets("Info Request").PrintOut
Next myC
End With

End Sub


HTH,
Bernie
MS Excel MVP


Pat,

Do you want an electronic copy, or a physical copy (a printout)?

HTH,
Bernie
MS Excel MVP






- Show quoted text -
Click to expand...

Bernie, right now I just want printed copies.
Pat
 
Back
Top