LinkBack URL
About LinkBacks
Dear AlphaFrog
Thanks for all your time and help.
Post marked SOLVED. Rep added.
Dear AlphaFrog
Thanks for all your time and help.
Post marked SOLVED. Rep added.
Last edited by sameer79; 10-12-2020 at 04:06 PM.
Will there be "ONLY" these 3 currencies, or "it may happen" that there will also be others ?
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi there,
Thank you so much. Works great.
If you could just tweak the code a bit to add few more things please.
See the sample attached
I have added the Ex Rates in Row 1 for US$, Euro and IND.
These cells will be fixed always displaying the Rates.
The exchange rates for US $ and Euro would change and that is the reason I want it be multiplied so when I change the Rate the values under Heading 8 will change accordingly.
Is it possible to get the values against each value under Heading5 multiplied by the Ex Rate according to the Number format and put the values under Col H.
I have done some manual multiplication and colored them for explanation purposes.
Blanks would be shown blanks
Hope you will help me.
Thanks once again for all your time and support.
Dear Porucha,
Currently we have only these 3 currencies
Thanks
Run this on text data in column E that has not yet been converted.
Please Login or Register to view this content.
Dear AlphaFrog,
Thanks a load for the revised code.
One small problem. When I run the code it replace the value in Cell H1 with =$E1*$M$1.
I am typing the old value back.
Just thought to update you.
Once again thanks for all the time and help.
Please Login or Register to view this content.
Dear Alpha Frog,
Thanks for the excel lend code you gave me.
One small problem I am facing now.
I want all the output under Col H to show IND instead of Euro and $.
Can you please amend it. Rest everything is fine.
Thanks once again for your time and help.
I'm not familiar with Indian currency formatting. I know there is a difference in number grouping.
Perhaps this would help...
https://chandoo.org/wp/indian-currency-format-excel/
Change the .NumberFormat = "$#,##0.00_);[Red]($#,##0.00)" to suit.
Dear AlphaFrog,
Thank you once again for all your time and help. It worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks