I have a sheet formatted as follows:
A B C
HEADER ROW
HEADER ROW
101 1-1-10 Address
102 1-3-10 Address
103 2-8-10 Address
I need to create some code to do the following:
Create a new sheet named "Labels"
Copy original sheet A3 to new sheet A1
Merge Cells A1:B6
Copy original sheet B3 to new sheet C1
Copy original sheet C3 to new sheet D1
Add page Break
Do the same as above for the next row on the original sheet and so on. Could
be unlimited number of rows on original sheet.
Any help is greatly appreciated. Thanks
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200910/1