Forum Discussion
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
- JamilBronze Contributor
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 MooreCopper Contributor
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.