Evening all,
i have a worksheet sheet that contains my raw stock data from a couple of stores. Top row is the date with the first column being the list of goods and the corresponding volume of that stock on the set date. Each date also has a price attached to it.
On a seperate worksheet I take use the raw data to understand how much stock I have at each price and and for how long.
The issue I have is that on the working sheet I have set formula looking at the cells in the raw data sheet. But each week I add in a new set of raw data but the formula is looking at the wrong cell. Is there a better way to do this?
i have a worksheet sheet that contains my raw stock data from a couple of stores. Top row is the date with the first column being the list of goods and the corresponding volume of that stock on the set date. Each date also has a price attached to it.
On a seperate worksheet I take use the raw data to understand how much stock I have at each price and and for how long.
The issue I have is that on the working sheet I have set formula looking at the cells in the raw data sheet. But each week I add in a new set of raw data but the formula is looking at the wrong cell. Is there a better way to do this?