3-D Reference Help

ramaxac

New Member
Joined
Jan 21, 2021
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Apologies if this has already been asked. I have one "Master" page in excel with a running inventory. Subsequent pages in that workbook are fulfilled orders, and I've set it up so that each page's inventory is the same - in other words, cell B15 in Master is the starting count of Type B Brochures, cell C15 in Master is the current count after orders are fulfilled. C15 in each order sheet is the number of Type B Brochures fulfilled. How do I deduct the value in all order sheets from the Master and can I have it auto-update when I add a new order sheet?
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
4,625
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Consider the approach that follows
- insert a blank sheet before the first relevant transaction sheet; name it Start
- insert a blank sheet after the last relevant transaction sheet; name it End
- ensure only relevant sheets are in this range

Review the structure and try the formula.
N.B. You can copy this example and paste it into a clean sheet; see the icon below the F(x).

The formula requires data sheets similar to what you described.

3d 2021.xlsm
ABCDEF
14AdditionsSalesBalance
15Type B Brochures1000605905700
16
Summary
Cell Formulas
RangeFormula
D15:E15D15=SUM(Start:End!D15)
F15F15=B15+D15-E15
 

Watch MrExcel Video

Forum statistics

Threads
1,126,986
Messages
5,621,995
Members
415,873
Latest member
fuulhouse

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
Top