Need help with Sums/Multiple Excel Sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3180246%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20Sums%2FMultiple%20Excel%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180246%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20file%20with%2028%20sheets.%20The%20first%20being%20the%20%22Master%22%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20sheet%20has%20an%20inventory%20control%20column.%20The%20number%20of%20rows%20is%20determined%20by%20the%20number%20of%20days%20in%20that%20month%20for%20that%20sheet.%20The%20column%20goes%20down%20in%20days%201%2C%202%2C%203%20and%20so%20on.%20Each%20day%20a%20new%20inventory%20number%20is%20entered%20for%20that%20specific%20item%20on%20its%20sheet.%20Then%20it%20is%20re-entered%20on%20the%20%22Master%22%20sheet.%20I%20need%20to%20figure%20out%20how%20to%20do%20one%20of%20two%20things%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Enter%20the%20inventory%20into%20the%20Master%20sheet%20and%20it%20update%20the%20columns%20daily.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOR%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Enter%20the%20inventory%20into%20each%20sheet%20daily%20and%20it%20update%20the%20Master%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20fine%20with%20either%20and%20really%20need%20help%20on%20how%20to%20create%20this%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3180246%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3180670%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Sums%2FMultiple%20Excel%20Sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3180670%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1310539%22%20target%3D%22_blank%22%3E%40JDEller%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends%20on%20how%20your%20data%20is%20structured%20exactly%20(in%20particular%2C%20do%20you%20have%20some%20ID%3As%20or%20not)%2C%20do%20you%20edit%2Fappend%20data%20in%20Master%20sheet%2C%20and%20on%20your%20version%20of%20Excel.%20In%20general%20that%20could%20be%20any%20lookup%20function%2C%20Power%20Query%20or%20dynamic%20arrays%20to%20collect%20data%20in%20Master%20sheet.%3C%2FP%3E%0A%3CP%3EBetter%20with%20small%20sample%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have an Excel file with 28 sheets. The first being the "Master" sheet. 

 

Each sheet has an inventory control column. The number of rows is determined by the number of days in that month for that sheet. The column goes down in days 1, 2, 3 and so on. Each day a new inventory number is entered for that specific item on its sheet. Then it is re-entered on the "Master" sheet. I need to figure out how to do one of two things:

 

1. Enter the inventory into the Master sheet and it update the columns daily.

 

OR

 

2. Enter the inventory into each sheet daily and it update the Master sheet.

 

I am fine with either and really need help on how to create this formula.

 

Thanks!

1 Reply

@JDEller 

It depends on how your data is structured exactly (in particular, do you have some ID:s or not), do you edit/append data in Master sheet, and on your version of Excel. In general that could be any lookup function, Power Query or dynamic arrays to collect data in Master sheet.

Better with small sample file.