Hi all,

I confess I know nothing about programming, so I’m hoping someone here can help me out.

I have a workbook with a worksheet called “LabelData” and I need to read cells from it and put them on a label worksheet. I already have a working macro that brings in the info for this “LabelData” worksheet from another workbook.

1. LabelData screenshot.jpg

This is what the worksheet “LabelPage” should look like after reading in the data. Two labels across, and down until all the “LabelData” rows have been read.

2. LabelPage screenshot.jpg

Here’s how the data is put together on each label.

3. Label format screenshot.jpg

There is a sheet called “LabelMaster” that contains two labels across with the column widths, row heights, fonts, justification and graphics on it. I would like the macro to copy these each time a new row of labels is required.

I really appreciate any help you people can provide.

Thanks in advance.