Help with applying function to cells

[scott682]

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

 

[mudraker]

Scott

You will need to copy the formula down column F

There are several ways to do this

goto the last row that has your parts listed in it

select the cell for that last row in column F

press the Ctrl & Up Arrow keys - this should selct all cells up to F
(based on your example)

Press Ctrl D

or

Edit Menu > Fill > Fill Dow

 

[scott682]

haha, wow, thanks mudraker

That easy!

Very much appreciated


Best regards,
Scot