Autp Populate Cells on a Different Sheet within a Document

[sandeeprice]

I have been trying to figure this out for 3 days and am at the end of my rope.

I am designing a spreadsheet for a construction firm. The workbook contains an the estimate, client proposal and the PO's for 3 different vendors. On the estimate I have a dropdown list for the vendor, category and product. When you select the vendor, the category is populated with only that vendors products and the same with the product.

What I would like to do is when the vendor product is selected, I want the product to auto populate on their PO sheet.
ESTIMATE:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Vendor
[/TD]
[TD]Category
[/TD]
[TD]Product
[/TD]
[/TR]
[TR]
[TD]Jones Wholesale Lumber
[/TD]
[TD]RIGIDLAM 2.0E LVL
[/TD]
[TD]Ridgidrim LVL: 3-1/2" Grade
[/TD]
[/TR]
[TR]
[TD]Shale Companies
[/TD]
[TD]PEB
[/TD]
[TD]PEB 2 x 4 Pad Block
[/TD]
[/TR]
[TR]
[TD]Reno Hardware
[/TD]
[TD]16" iJoist
[/TD]
[TD]16" iJoist LBV 37/16
[/TD]
[/TR]
</tbody>[/TABLE]


PO:
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 893"]
<colgroup><col><col span="3"><col><col span="4"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]PURCHASE ORDER[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]DATE:[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]P.O. NUMBER:[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]VENDOR:[/TD]
[TD="colspan: 3"]Jones Wholesale Lumber[/TD]
[TD][/TD]
[TD]SHIP TO:[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ATTN: [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]JOB SITE CONTACT:[/TD]
[TD="colspan: 3"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]REQUESTED DELIVERY DATE[/TD]
[TD="colspan: 2"]SHIP VIA[/TD]
[TD="colspan: 2"]F.O.B. POINT[/TD]
[TD="colspan: 2"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"] [/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"]ob Site
[/TD]
[TD="colspan: 2"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]PRODUCT[/TD]
[TD]QTY.[/TD]
[TD]LENGTH[/TD]
[TD]TOTAL QTY.[/TD]
[TD]UNIT PRICE[/TD]
[TD]TOTAL PRICES[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD="colspan: 5"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD] [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SUBTOTAL: [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]FREIGHT: [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TOTAL DUE: [/TD]
[TD]0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Is this possible? I know it has to be but for the life of me I can't figure it out. Any help will be greatly appreciated.

 

[AtlantaAccessAndExcel]

I am afraid you will need to populate via VBA. There is not a built-in Excel formula that will pull over the info from the Estimate tab.

Mark