Forum Discussion

Trudy Moore's avatar
Trudy Moore
Copper Contributor
Mar 30, 2018

Automate excel to copy a range from one sheet to another

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

excel
Excel on mobile
Excel Online
  • Jamil's avatar
    Jamil
    Bronze Contributor
    Mar 30, 2018

    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.

     

     

    • Trudy Moore's avatar
      Trudy Moore
      Copper Contributor
      Apr 02, 2018

      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.

Resources