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)?

Location	NSN	Nomenclature	Record Qty	UoI
bb2a06	534015459885	PLATE,MOUNTING	4	EA
BC08D5	473010927883	STRAINER ELEMENT,SE	4	EA
BC10A1	613015267838	POWER SUPPLY	0	EA
BC10A2	622011903149	LIGHT,RECOGNITION,A	0	EA

<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>
</tbody>

	SLOC:	bb2a06			SLOC:
	NSN:	534015459885			NSN:
	Noun:	PLATE,MOUNTING			Noun:
	On-Hand:	4			On-Hand:
	UI	EA			UI
	Authorized:				Authorized:
	Contract #:				Contract #:
	Date Prepared:				Date Prepared:

<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>
</tbody>

 

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