Merge data from one sheet to another and print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Glenn - 17 Jan 2007 14:48 GMT

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

Reply to this Message

Ron de Bruin - 17 Jan 2007 16:27 GMT

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

Signature

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

> Hi,
>
[quoted text clipped - 13 lines]
> Thanks,
> Glenn

Reply to this Message