Quote Originally Posted by NBVC View Post
Do you (or can you) have a separate column that shows the currency of each transaction?

Then you can have a lookup table of exchange rates and use VLOOKUP to capture the correct conversion and use that to get the £.
Sure - I have a blank page. So I can put in whatever is required. The only constant at this stage is the starting point of £60,000.

Could you explain a little more on the lookup idea? I use vlookup so I would be comfortable using this - just not sure on the starting point.