Forum Discussion
Trudy Moore
Mar 30, 2018Copper Contributor
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 ...
Jamil
Mar 30, 2018Bronze 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 Moore
Apr 02, 2018Copper 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.