Not sure how to do this easily?

[Blakes7]

Hi I have created a work book which is basically which is a stock control book which covers a fiscal year. my problem is that the prices are set in one column for each month by linking each month to the next separately this allow or price changes at the beginning of each month. For each month there are 5 columns which allows for a 5 week calendar months. The formulae for the first column calculate the usages based o the absolute value of the prices column. My question is how to copy the formulae from the first weeks column to the other columns without having to physically change the reference to the cells which contain the prices. If that makes sense?

 

[most]

Use dollar sign to lock row or column reference you don't want to change.

=$A$1