Insert Live Exchange Rate in a Document already containing thousands of items.

[MelSanz]

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

[vba_php]

Mel, this from you:

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)

doesn't say anything. It's never helpful to say ""it doesn't work"". and this by you:

. Is there a way to fill the sheet without spending hours entering the formula manually?

based on what I'm reading, that's what the autofill handle is for. I'm assuming you're saying that you've already tried that and it's not doing what it's supposed to do? and this:

I really need this price list updated soon.

probably won't yield a response from anyone. Just saying.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.