JAN FEB MAR
DESCRIPTION UNITS COST Current Price
1.5oz Round 12402 1000 7 5 6 7
45ml Hex 8880 1000
4oz Hex 4950 1000
4oz Rd 4800 1000

I am not sure if what i am going to ask is possible but i am hoping it is!!
I have the following table. Basically, i need the current price column to
always be 'current' i.e. picking up the new months data as it is entered. If
i enter a new price in month April, i would like the spreadsheet to
automatically update current price to aprils value. Obviously there is the
really easy manual way of doing this but i am hoping that there is an
automatic way.

Any help would be appreciated