Merge data from one sheet to another and print
 

Hi,

I have a workbook that has two worksheets in it.

Worksheet A contains a list of names and phone numbers.

Worksheet B is a form that contains some static information and a need for
some of the info from Worksheet A.

I'd like to set it up so that I can push a button on worksheet A that will
read the data from Row 1 Merge it into Worksheet B and print it, go to Row
2, do the same thing, etc.

Any suggestions on how to do this?

Thanks,
Glenn

Merge data from one sheet to another and print
 

Hi Glenn

Create Vlookup formulas in Worksheet B
Use for example the Name cell as lookup value (D1 in this example)

Then with the names in "Sheet1" in A1:A10 try this

Sub test()
With Sheets("Sheet2") ' << worksheet B
For Each cell In Sheets("Sheet1").Range("A1:A10")
'D1 is the name cell in Sheet2
.Range("D1").Value = cell.Value
.PrintOut preview:=True
Next cell
End With
End Sub

Delete preview:=True when it is working like you want



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Glenn" wrote in message ...
Hi,

I have a workbook that has two worksheets in it.

Worksheet A contains a list of names and phone numbers.

Worksheet B is a form that contains some static information and a need for
some of the info from Worksheet A.

I'd like to set it up so that I can push a button on worksheet A that will
read the data from Row 1 Merge it into Worksheet B and print it, go to Row
2, do the same thing, etc.

Any suggestions on how to do this?

Thanks,
Glenn