Auto Create Labels from Table Data

[MPridgeon88]

I am looking for assistance creating a formula toautofill labels from data in a table. Preferably a method that autofills insequence as there are thousands of lines to create labels for.


The table below has the information to be transposed onthe label. The challenge is getting the next label to transpose the informationfrom the next row in sequence, and subsequent rows thereafter transposed to thenext table (label).

Is there a way to copy/autofill the formula across thelabel thousands of times without having to manually enter the first value(SLOC)?





[TABLE="width: 439"]
<colgroup><col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;" span="2"><colgroup><col width="217" style="width: 163pt; mso-width-source: userset; mso-width-alt: 7936;"><colgroup><col width="64" style="width: 48pt;"><colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"><tbody>[TR]
[TD="width: 113"]Location
[/TD]
[TD="width: 113"]NSN[/TD]
[TD="width: 217"]Nomenclature[/TD]
[TD="width: 64"]Record Qty[/TD]
[TD="width: 77"]UoI[/TD]
[/TR]
[TR]
[TD]bb2a06[/TD]
[TD]534015459885[/TD]
[TD]PLATE,MOUNTING[/TD]
[TD]4[/TD]
[TD]EA[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]BC08D5[/TD]
[TD="bgcolor: transparent"]473010927883[/TD]
[TD="bgcolor: transparent"]STRAINER ELEMENT,SE [/TD]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"]EA[/TD]
[/TR]
[TR]
[TD]BC10A1[/TD]
[TD]613015267838[/TD]
[TD]POWER SUPPLY[/TD]
[TD]0[/TD]
[TD]EA[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]BC10A2[/TD]
[TD="bgcolor: transparent"]622011903149[/TD]
[TD="bgcolor: transparent"]LIGHT,RECOGNITION,A [/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]EA
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 594"]
<colgroup><col width="28" style="width: 21pt; mso-width-source: userset; mso-width-alt: 1024;"><colgroup><col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"><colgroup><col width="201" style="width: 151pt; mso-width-source: userset; mso-width-alt: 7350;"><colgroup><col width="64" style="width: 48pt;"><colgroup><col width="34" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1243;"><colgroup><col width="120" style="width: 90pt; mso-width-source: userset; mso-width-alt: 4388;"><colgroup><col width="169" style="width: 127pt; mso-width-source: userset; mso-width-alt: 6180;"><colgroup><col width="64" style="width: 48pt;"><tbody>[TR]
[TD="width: 28, bgcolor: transparent"][/TD]
[TD="width: 110, bgcolor: transparent"][/TD]
[TD="width: 201, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 34, bgcolor: transparent"][/TD]
[TD="width: 120, bgcolor: transparent"][/TD]
[TD="width: 169, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]SLOC:[/TD]
[TD="bgcolor: transparent"]bb2a06[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]SLOC:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]NSN:[/TD]
[TD="bgcolor: transparent"]534015459885[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]NSN:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Noun:[/TD]
[TD="bgcolor: transparent"]PLATE,MOUNTING[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Noun:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]On-Hand:[/TD]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]On-Hand:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]UI[/TD]
[TD="bgcolor: transparent"]EA[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]UI[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Authorized:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Authorized:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Contract #:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Contract #:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Date Prepared:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Date Prepared:[/TD]
[TD="bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[nardagus]

IMO if you want to use excel for that you'd need a macro.

However. I know this is EXCEL forum, but I have a feeling sometimes people tend to forget how powerfull can be a combo of WORD and EXCEL. Especially when it comes to generating hundreds or thousands of labels.
Just put all the data in excel and then create labels using MAIL MERGE function...