0

I have reviewed a handful of methods to combine ranges (ie: let formula, VBA via Union, setting your own Lambda formula) and I am looking to find the most concise way to achieve the following.

  1. I have a range that exists in the same spot across multiple worksheets.
  2. My worksheets are numbered 1 through XX (some worksheets have 10 tabs some have 100+).
  3. I would like to aggregate all of the sheets (1,2,3,4,etc) into one tab.

What would be the most efficient way to accomplish this? And let me know if any other information is necessary! Thanks in advance for your help Stack Overflow community!

user2395032
  • 1
  • Formula will not be the best suited for this. You will want vba, that iterates the sheets and copies the data correctly. Stack Overflow is not a code for me site. Please attempt on your own and come back with a specific problem with the code that needs to be overcome. – Scott Craner Jun 14 '21 at 19:35

0 Answers0