Hi folks
I am busy doing a price list for a product we import. I need to multiply each price by a number contained in a cell to work out my landed cost.
To elaborate:
I have a value in Cell D8 that is my multiplier for customs and Tax. Each price on the price list needs to refer to this cell to give me a total in the corresponding cell in column G.
IE: =F13*D8, =F14*D8, =F15*D8 etc
When I try copy the first one (=F13*D8) to the cells in G column, it keeps changing the D8.
IE: =F13*D8, =F14*D9, =F15*D10
How do I copy / paste so that it keeps the reference to D8, but changes the F numbers?
I hope I have been clear enough in my explanation!
Thanks for the time
Bookmarks