I'm quite a beginner with excel and was wondering if anyone can help me with either a formula or a macro.
I have a testing document where electricians record if fittings pass or fail. If a fitting fails I want to be able to provide a quote to the customer.
So I have 3 cells where I choose the brand of fitting, then the type of fitting and then if the entire fitting requires replacement or just the bulb. From there I want to populate another cell with the price. However this will mean that Excel will need to check 5 attached workbooks for the correct one (each workbook is for a different brand of fitting) and then the type of fitting and then how its to be fixed, from there it needs to find a price.
If anyone can help please let me know so I can send you the spreadsheet (not sure how to attach)
Thanks in advance.
I'm quite a beginner with excel and was wondering if anyone can help me with either a formula or a macro.
I have a testing document where electricians record if fittings pass or fail. If a fitting fails I want to be able to provide a quote to the customer.
So I have 3 cells where I choose the brand of fitting, then the type of fitting and then if the entire fitting requires replacement or just the bulb. From there I want to populate another cell with the price. However this will mean that Excel will need to check 5 attached workbooks for the correct one (each workbook is for a different brand of fitting) and then the type of fitting and then how its to be fixed, from there it needs to find a price.
If anyone can help please let me know so I can send you the spreadsheet (not sure how to attach)
Thanks in advance.
I have a testing document where electricians record if fittings pass or fail. If a fitting fails I want to be able to provide a quote to the customer.
So I have 3 cells where I choose the brand of fitting, then the type of fitting and then if the entire fitting requires replacement or just the bulb. From there I want to populate another cell with the price. However this will mean that Excel will need to check 5 attached workbooks for the correct one (each workbook is for a different brand of fitting) and then the type of fitting and then how its to be fixed, from there it needs to find a price.
If anyone can help please let me know so I can send you the spreadsheet (not sure how to attach)
Thanks in advance.
I'm quite a beginner with excel and was wondering if anyone can help me with either a formula or a macro.
I have a testing document where electricians record if fittings pass or fail. If a fitting fails I want to be able to provide a quote to the customer.
So I have 3 cells where I choose the brand of fitting, then the type of fitting and then if the entire fitting requires replacement or just the bulb. From there I want to populate another cell with the price. However this will mean that Excel will need to check 5 attached workbooks for the correct one (each workbook is for a different brand of fitting) and then the type of fitting and then how its to be fixed, from there it needs to find a price.
If anyone can help please let me know so I can send you the spreadsheet (not sure how to attach)
Thanks in advance.
