Hi Everyone,
I understand how to add the live exchange rate, it works very well but my issue is that I am trying to add this to a document that is already created and that has thousands of items in USD and it needs to be in CAD. I created a NEW column for CAD and I can do the first price fine but when I try to fill the column for all the other prices, it doesn't work (it tries to use the next currency down the table). Is there a way to fill the sheet without spending hours entering the formula manually? I really need this price list updated soon.
Thank you in advance for your suggestions.
Mel Sanz
Bookmarks