copy certain cells from one sheet to another label-type sheet with concatenation

Stretcher

New Member
Joined
Mar 25, 2013
Messages
2
Hi all, just joined today.

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.https://www.box.com/s/9e1heqsnaxftlyc1md6j


This is what the worksheet “LabelPage” should look like after reading in the data. https://www.box.com/s/r633fyotgsxxsydtmiup Two labels across, and down until all the “LabelData” rows have been read. Here’s how the data is put together on each label. https://www.box.com/s/oklwbg1sfj5m3o4om72p 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. P.S. Sorry about the disorganized paragraphs, I can't seem to enter a hard return in the editor.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
In case you can't see the Box.com images, here are the images via PhotoBucket.
1LabelDatascreenshot.jpg
2LabelPagescreenshot.jpg
3Labelformatscreenshot.jpg
 
Upvote 0

Forum statistics

Threads
1,223,170
Messages
6,170,474
Members
452,330
Latest member
AFK_Matrix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top