dynamic column reference, copy formula down

Ive got this macro rounding numbers and copying the formula down but not sure how to make a dynamic column reference.
In the code ive put the header Price2 in column I specifically, this wouldnt be the case normally, in reality id have to search for the header "Price2" which probably
wont be in 'column I' ..how would i make the references to the "Price2" header dynamic?

Please Login or Register  to view this content.

amend the last part to

Please Login or Register  to view this content.

as long as the formula should always look 6 columns to the left

thats the thing, the 'Price2' header can be on any column (thats why i have this bit... Find("Price2", LookAt:=xlWhole).Column) and the dataset will have more columns from time to time, so that the 'Price2' header can more than 6 columns from column C where the origianl 'Price' column is located.

so do you need the code to look at the Price column wherever that may be? if so the formula will be

Please Login or Register  to view this content.

many many thanks Joseph, this works nicely:

Please Login or Register  to view this content.