Hi,

I have a spare parts pricelist that is in Euro currency - what I nee
to do is convert these prices in a seperate column, to Aussie dollar.

(refer to the attached xls) You will see I have the code required fo
the conversion in the cells F3-F6, but need to apply this to the res
of the F column (without having to do it manually - as my origina
parts list has over 5000 entries).

How would I go about applying this as an automatic bit of code?

Any help would be greatly appreciated.

Thanks,
Scot

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=65176
--
Message posted from http://www.ExcelForum.com