I have a very nice WB that I have been using in the U.S. Most recently, I have had the request to use it in Europe. Here's what I'm interested in knowing;
1.) Is there a way to create a Macro that when "fired" will look through a WB or specific Worksheets and change the formatting (i.e. currency to another currency SIGN; so e.g. dollars to euros, or pounds or Yen)?
2.) For graphics with the need for the same currency sign change, can I use the "Linked to source" choice in the graphic to reflect the change in currency or will I have to do something more creative?
I do not need currency conversion. I need currency formatting.
Thank you in advance for sharing any expertise in this area.