populating production sheets

cocciaaccounting

New Member
Joined
Jul 22, 2013
Messages
1
Hello everybody.

I currently work at a company that produces whey protein products. For are first few years operating we have been using excel forms to produce are formulas and production sheets, but each time we do a new job, we have to manually enter in all of the information for each job like part numbers and description etc... We use a Inventory database that creates a Bill of Materials for each job based off of 1 unit of that job which may have 12 different ingrediens in it.... I guess what I am getting at is that we would like to be able to export a BOM out of the database and into an excel worksheet and then from there populate are sheets based off of that BOM by only having to click on a dropdown box which contains all of the job #'s. Were very good at using excel for what we currently do but are knowledge beyond that concerning pivot tables, controls VBA code etc... is not great. Here is are production sheet which we would like to be able to populate. Sorry if this makes no sense, its a very tough industry to try to explain but any input would be greatly appreciated.

[TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 135, bgcolor: transparent, colspan: 2"]Customer:
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 531"]
<colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <col width="17" style="width: 13pt; mso-width-source: userset; mso-width-alt: 621;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="64" style="width: 48pt;" span="2"> <col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <tbody>[TR]
[TD="class: xl138, width: 107, bgcolor: transparent, colspan: 2"]Customer:
[/TD]
[TD="class: xl144, width: 188, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, width: 137, bgcolor: transparent, colspan: 2"]Lot #:[/TD]
[TD="class: xl157, width: 208, bgcolor: yellow, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]Blend Sample#:[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl154, bgcolor: yellow, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Salesman:[/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Production Date:[/TD]
[TD="class: xl151, bgcolor: #DCE6F1, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Product Code: [/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 10"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Product Name:[/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Blend Size:[/TD]
[TD="class: xl140, bgcolor: #DCE6F1, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl83, bgcolor: transparent, colspan: 12"] [/TD]
[/TR]
[TR]
[TD="class: xl161, bgcolor: transparent, colspan: 2"]Formulated by;[/TD]
[TD="class: xl146, bgcolor: transparent, colspan: 10"]Paul[/TD]
[/TR]
[TR]
[TD="class: xl144, bgcolor: transparent, colspan: 12"]Revision: [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl102, bgcolor: transparent"]Fill Wt:[/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl166, bgcolor: transparent, colspan: 2"]Stamp Data[/TD]
[TD="class: xl99, bgcolor: transparent"]Line1:[/TD]
[TD="class: xl100, bgcolor: transparent"]Lot#[/TD]
[TD="class: xl98, bgcolor: transparent"]Line2: [/TD]
[TD="class: xl103, bgcolor: transparent"]Mfr Date[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl104, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl105, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]PART#[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"] [/TD]
[TD="class: xl149, bgcolor: transparent"]Description[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Container[/TD]
[TD="class: xl170, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Lid[/TD]
[TD="class: xl170, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Lid2[/TD]
[TD="class: xl132, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Scoop (Y/N)[/TD]
[TD="class: xl132, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Box Size[/TD]
[TD="class: xl169, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"]Qty/Box: [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]ShrinkBand (Y/N)[/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl136, bgcolor: transparent, colspan: 2"]Label (Y/N)[/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]Label [/TD]
[TD="class: xl118, bgcolor: transparent, colspan: 3"]Ingredients[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 3"]Total per batch[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"]Weighed[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"]Mixed[/TD]
[TD="class: xl73, bgcolor: transparent"]Lot#[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"]kg[/TD]
[TD="class: xl73, bgcolor: transparent"]gm[/TD]
[TD="class: xl73, bgcolor: transparent"]lbs[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl117, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl114, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl107, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl116, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/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="class: xl109, bgcolor: transparent, align: right"]0.0000[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent, colspan: 3"]Blending Time 20 mins[/TD]
[TD="class: xl126, bgcolor: transparent, colspan: 2"]Blender #[/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]
[TR]
[TD="class: xl95, bgcolor: transparent"]Start[/TD]
[TD="class: xl130, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl124, bgcolor: yellow, colspan: 2"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: transparent, colspan: 5"]Scale Weights Verfied By: ______________________________[/TD]
[/TR]
[TR]
[TD="class: xl96, bgcolor: transparent"]Stop [/TD]
[TD="class: xl130, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl126, bgcolor: transparent, colspan: 2"]Scale #[/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]
[TR]
[TD="class: xl91, bgcolor: transparent"]Date[/TD]
[TD="class: xl164, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl128, bgcolor: yellow, colspan: 2"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: transparent, colspan: 5"]Notes/Adjustments to Blend (if any): ______________________[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:

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