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 ...
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.
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.