Hi
I have receipts in UK pounds that are listed in Column F rows 6 to 25.
I have the exchange rate to Euros in Cell C4.
How do I simply convert all the currencies rather than doing each cell individually (F6/C4; F7/C4; F8/C4 etc)?
Help much appreciated.
David
Bookmarks