I have a “template” in my stock tracking spreadsheet that I use each time I purchase a stock. I simply cut/paste the rows to the blank area at the top of the sheet and change the static values; name, date, price, quantity, etc.
Currently, all cell references are relative, to allow copying the block of text to a new location.
However, the bottom row of the template is a daily tracking row. If I want to add a new date, I copy that row and update the values. I would like that row to contain absolute references to the quantity and original cost. If I make them absolutes in the template, they point to the wrong location when I use them to create a new stock entry.
So, I would like to be able to copy multiple rows containing formulas that contain absolute references, with everything treated as a relative reference for just that one time.