Update/refresh button

Originally Posted by davesexcel

Sub CopyNewPricees()

'1 sheet named New Prices
'1 sheet named Price List
'this code copies the new prices to the price list
'change ranges as required
    Sheets("New Prices").Range("A1:A15").Copy Destination:=Sheets("Price List").Range("I1")
End Sub

Thanks for the fast reply. I probobly should have mentioned that I am quite a newbie at Excel so could you please explain a little more. Do I make a button or how do I do this?
Hope you can bare with me
Lets say the the the cell with old prices is G3 and the new is G4 and they are both in the same sheet