Excel Clarification
folks,
could you please advise of the attached template.
1. i have multiple vendors ,where if i select one vendor with either product or warranty , corresponding discount number should highlight as mentioned
2. IF i add price , lets say USD , how can i automate to convert to aed
3. similarly for point 1 , i need to mentioned, if it is warranty, there is no customs charge to be added, rest it would be as per table
Could you please advise and assist as per template.
BR,
Sid
test-2.xlsx
could you please advise of the attached template.
1. i have multiple vendors ,where if i select one vendor with either product or warranty , corresponding discount number should highlight as mentioned
2. IF i add price , lets say USD , how can i automate to convert to aed
3. similarly for point 1 , i need to mentioned, if it is warranty, there is no customs charge to be added, rest it would be as per table
Could you please advise and assist as per template.
BR,
Sid
test-2.xlsx
ASKER
Hi thanks for the reply
i was looking something like as attached .
1 LEts say i have two vendors , Cisco , Juniper , each has product and warranty, when i select through dropdown Cisco + Product i should get corresponding discount value , similarly if i select Juniper + warranty , i should get corresponding discount value , so there will be two cells , ie Vendor , Subgroup etc
2. Secondly In the first sheet , i know how to make vertical dropdown list, but how can i make dropdo
wnlist for horizontal section , as seen in sheet3 , there is product and warranty horizontally placed
3. when i enter price and select currency , it should automatically covert to aed , eg: if i enter value 10 in unit price and select currency usd, it should convert to aed automatically. also when product is selected , it should be multipled with 1.0X as mentioned in the sheet .
test-2.xlsx
i was looking something like as attached .
1 LEts say i have two vendors , Cisco , Juniper , each has product and warranty, when i select through dropdown Cisco + Product i should get corresponding discount value , similarly if i select Juniper + warranty , i should get corresponding discount value , so there will be two cells , ie Vendor , Subgroup etc
2. Secondly In the first sheet , i know how to make vertical dropdown list, but how can i make dropdo
wnlist for horizontal section , as seen in sheet3 , there is product and warranty horizontally placed
3. when i enter price and select currency , it should automatically covert to aed , eg: if i enter value 10 in unit price and select currency usd, it should convert to aed automatically. also when product is selected , it should be multipled with 1.0X as mentioned in the sheet .
test-2.xlsx
I believe this is what you are looking for...
Now converting it to AED i need to have the conversion rate for each currency which you want to use and then accordingly i can set up a formula for the same..So if you can provide me the conversion rate i can set the rest of the formula for you...
Saurabh...
test-2-1.xlsx
Now converting it to AED i need to have the conversion rate for each currency which you want to use and then accordingly i can set up a formula for the same..So if you can provide me the conversion rate i can set the rest of the formula for you...
Saurabh...
test-2-1.xlsx
I think you need a VBA solution to achieve what you are asking because you cannot replace a manual input by a formula or vice versa.
Please find the attached workbook where a drop down in col. C has been added to select SubGroup.
After downloading the file, don't forget to enable the macros/editing/contents while prompted when opening the file first time.
Follow these steps to test the code.
1) Select Vendor in col. B.
2) Select SubGroup in col. C.
3) Input Qty in col. F.
4) Input Unit Price in col. G.
5) Formula to calculate the Total Price in col. H is already in place.
6) Discount% will be calculated as per the previous formula in col. I.
7) Now select the currency type in col. J and once you do so, the Unit Price will be automatically converted to AED.
8) The lookup table for currency conversion is on Sheet3.
test-2.xlsm
Please find the attached workbook where a drop down in col. C has been added to select SubGroup.
After downloading the file, don't forget to enable the macros/editing/contents while prompted when opening the file first time.
Follow these steps to test the code.
1) Select Vendor in col. B.
2) Select SubGroup in col. C.
3) Input Qty in col. F.
4) Input Unit Price in col. G.
5) Formula to calculate the Total Price in col. H is already in place.
6) Discount% will be calculated as per the previous formula in col. I.
7) Now select the currency type in col. J and once you do so, the Unit Price will be automatically converted to AED.
8) The lookup table for currency conversion is on Sheet3.
test-2.xlsm
ASKER
Thanks Bro's .. I see some automations in it .
for exchange it is
1 USD = 3.67 AED
1GBP=5.67 AED
1 EURO = 4.65 AED
may i know some clarifications
1. Relateed with the currency, what i require is , if i enter a value in unit price and select currency , coversion should take place and i beleive this is what the formula does right .
REgards,
SID
for exchange it is
1 USD = 3.67 AED
1GBP=5.67 AED
1 EURO = 4.65 AED
may i know some clarifications
1. Relateed with the currency, what i require is , if i enter a value in unit price and select currency , coversion should take place and i beleive this is what the formula does right .
REgards,
SID
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@infiniti
One of your previous question has been re opened by the moderator, please re assign the points by accepting the solutions.
The link to your previous question is this......
https://www.experts-exchange.com/questions/28708906/Select-Multiple-Names-from-Cell.html?anchorAnswerId=40951208#a40951208
One of your previous question has been re opened by the moderator, please re assign the points by accepting the solutions.
The link to your previous question is this......
https://www.experts-exchange.com/questions/28708906/Select-Multiple-Names-from-Cell.html?anchorAnswerId=40951208#a40951208
Looking at your data i'm not sure where you want the results to be populated. If you can provide me a more context about which sheet you want the results to be populated and what results you are expecting. It will be faster to design for a solution for you accordingly..
Saurabh...