Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel file link with two worksheet calculation
Hi ,
Could anyone help me. I had a excel file consist of sheet 1 and sheet 2. Sheet 1 consist of a table of different country freight cost. Sheet 2 is a standard template to calculate the actual total cost. If I entered 100 and Origin Italy it will auto take 100*0.65*2.1=136.5 as formula The Fuel and security also convert according Sheet 1 Table Airport Dest Currency Origin Min -45 +45 +100 +500 ABC SIN USD USA 35 0.36 0.31 0.27 0.26 Rate 1.45 Fuel USD 0.55/kg Security USD 0.17/kg Airport Dest Currency Origin Min -45 +45 +100 +500 EFG SIN EUR Italy 40 0.55 0.66 0.65 0.64 Rate 2.1 Fuel EUR 0.45/kg Security EUR 0.20/kg Airport Dest Currency Origin Min -45 +45 +100 +500 HIJ SIN AUD Aust 40 0.55 0.40 0.39 0.38 Rate 1.1 Fuel AUD 0.35/kg Security AUD 0.25/kg Sheet 2 Template Origin Italy Airport Description Rate Comment Eur Port to Port 136.5 (100*0.65*2.1) SIN Agency Fee 45 SIN Delivery Charge 30 SIN DO Fee 60 SIN Permit Fee 60 SIN Wharfage 60 EUR Fuel 115.5 (0.55*100*2.1) EUR Security 35.7 ( 0.17*100*2.1) SIN Total 542.70 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link a file to worksheet | Excel Discussion (Misc queries) | |||
Personal File Link with Worksheet | Excel Discussion (Misc queries) | |||
Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
Excel file link with word file | Excel Worksheet Functions | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |