Mar 30 2018 02:24 PM
I am needing help to move information from one sheet automatically into another when entered. Each sheet has it's own information working off of lists and there will be about 50 or so sheets. What I need it to do is summarize that information from each individual sheet into a separate summary sheet when it is entered into it's own individual sheet. Can anyone help. I have attached the fill as I don't know how to explain what I need to "learn" to do. I don't want to have to individual link each cell in each sheet to the summary page.
Thanks So Much
Mar 30 2018 03:02 PM - edited Mar 30 2018 03:02 PM
you can use the Dynamic Sheetnames inside formula with INDIRECT function. Please see the attached example I uploaded. I added a helper column in the summary sheet to have the sheet names in them and that is it.
Apr 02 2018 09:48 AM
Thank you Jamil ! I have tried to duplicate your example in other workbooks but have been unable to get it right. I would appreciate it very much if you could walk me through how.