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:

Vendor	Category	Product
Jones Wholesale Lumber	RIGIDLAM 2.0E LVL	Ridgidrim LVL: 3-1/2" Grade
Shale Companies	PEB	PEB 2 x 4 Pad Block
Reno Hardware	16" iJoist	16" iJoist LBV 37/16

<tbody>
</tbody>

PO:

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

<tbody>
</tbody>

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