Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relationships / Calculations
Hi all, I have two sheets, first is for calculating invoice and other one is for storing product details (simple database). Sheet #1 contains following columns: A: Product ID B: Description C: Manufacturer D: Quantity E: Price per unit F: Subtotal Sheet#2 contains folowing columns: A: Product ID B: Description C: Manufacturer D: Price per unit What I need is when I type ID and QUANTITY of the product into the sheet#1 Excel should automaticly fill the remaining fields (from sheet#2) and do the calculations. // Example: ID DESC. MANUFACT. QUANT. PRICE/UNIT SUBTOTAL -------------------------------------------------------------------------------- 1001 BEER HEINEKEN 20 $5.00 $100.00 -------------------------------------------------------------------------------- 1030 SHIRT NIKE 1 $15.00 $15.00 -------------------------------------------------------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex calculations | Excel Discussion (Misc queries) | |||
Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
looping through a set of calculations | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
time interval calculations in excel | Excel Discussion (Misc queries) |