Weekly updating raw data

beng986

Board Regular
Joined
Jan 10, 2012
Messages
88
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?
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Have you tried a Pivot Table?

Or if you need dynamic formulas you can set up the raw data in a table format and use structured references.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top