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.
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.