Automate Master Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2776051%22%20slang%3D%22en-US%22%3EAutomate%20Master%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2776051%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20that%20contains%209%20worksheets%20plus%20a%20Master%20sheet%2C%20all%20have%20tables%20I%20need%20the%20data%20from%20the%209%20worksheets%20to%20update%20the%20Master%20sheet%20without%20using%20vba%20or%20macros.%20I%20used%20the%20vlookup%20formula%20on%20the%20master%20sheet%20but%20doesn't%20self%20populate.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2776051%22%20slang%3D%22en-US%22%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-2776395%22%20slang%3D%22en-US%22%3ERe%3A%20Automate%20Master%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2776395%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1163820%22%20target%3D%22_blank%22%3E%40Rob5443%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20able%20to%20share%20either%20the%20actual%20workbook%20or%20a%20facsimile%20(not%20an%20image%2C%20an%20Excel%20workbook%20with%20false%20data)%2C%20it%20would%20be%20a%20LOT%20easier%20to%20see%20exactly%20what%20you're%20working%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you're%20not%20able%20to%20do%20that%2C%20a%20question%20and%20suggestion%3A%3C%2FP%3E%3CUL%3E%3CLI%3EAre%20the%209%20worksheets%20laid%20out%20in%20the%20same%20fashion%3F%20If%20so%2C%20you%20might%20find%20the%20INDIRECT%20function%20helpful%20--%20I%20use%20it%20in%20a%20similar%20situation%2C%20to%20extract%20data%20from%20subordinate%20sheets%20to%20a%20summary%20master%2C%20where%20all%20of%20the%20subordinates%20are%20arrayed%20similarly.%3C%2FLI%3E%3CLI%3EHere's%20a%20useful%20reference%20on%20INDIRECT%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-indirect-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-indirect-function%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a workbook that contains 9 worksheets plus a Master sheet, all have tables I need the data from the 9 worksheets to update the Master sheet without using vba or macros. I used the vlookup formula on the master sheet but doesn't self populate.

1 Reply

@Rob5443 

 

If you are able to share either the actual workbook or a facsimile (not an image, an Excel workbook with false data), it would be a LOT easier to see exactly what you're working with.

 

If you're not able to do that, a question and suggestion:

  • Are the 9 worksheets laid out in the same fashion? If so, you might find the INDIRECT function helpful -- I use it in a similar situation, to extract data from subordinate sheets to a summary master, where all of the subordinates are arrayed similarly.
  • Here's a useful reference on INDIRECT: https://exceljet.net/excel-functions/excel-indirect-function
  •