Help on Excel
I need to create a reference link to use Excel to produce a quotation
calculator. I want a column of Product codes, a colum of cost prices and an option on margins to be made then a sum at the end. I want to make a sheet take data from other sheets within the same workbook with dropdown options i.e. You choose "Product A" from a dropdown list and automatically the cost price of Product A appears in column B...there is a dropdown menu on column C offering 15%, 20%, 25% etc. and this will automatically calculate a "Sale Price" in column D. Is this possible? |
Help on Excel
in column B, use
=VLOOKUP(A2,product_table,2,False) and sale price as =b2*(1+c2) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Caseshopcom" wrote in message ... I need to create a reference link to use Excel to produce a quotation calculator. I want a column of Product codes, a colum of cost prices and an option on margins to be made then a sum at the end. I want to make a sheet take data from other sheets within the same workbook with dropdown options i.e. You choose "Product A" from a dropdown list and automatically the cost price of Product A appears in column B...there is a dropdown menu on column C offering 15%, 20%, 25% etc. and this will automatically calculate a "Sale Price" in column D. Is this possible? |
All times are GMT +1. The time now is 10:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com