Hello,
I would be very grateful if anyone has any good ideas to make this code more general.
I am currently using this long formula to pull an ARRAY of data from various workbooks. The code works.... but there must be a more general way to do it. Especially if i want to add more books, then it becomes longwinded to type them out
=INDIRECT(Finance!$A$4&".xlsx!"&AT9)
+INDIRECT(Finance!$A$5&".xlsx!"&AT9)
+INDIRECT(Finance!$A$6&".xlsx!"&AT9)
+INDIRECT(Finance!$A$7&".xlsx!"&AT9)
+INDIRECT(Finance!$A$8&".xlsx!"&AT9)
+INDIRECT(Finance!$A$9&".xlsx!"&AT9)
+INDIRECT(Finance!$A$10&".xlsx!"&AT9)
+INDIRECT(Finance!$A$11&".xlsx!"&AT9)
+INDIRECT(Finance!$A$12&".xlsx!"&AT9)
+INDIRECT(Finance!$A$13&".xlsx!"&AT9)
If you resolve the first line it looks like this =Indirect("C0463.xlsx!$D$16:$CY$16")
So the question is... how can i reduce this code into a single line by using the range A4:A13 instead of A4+A5+A6+A7+A8+A9...+A13
Id like it as a single line in the formula bar, so no VBA please.
Also, this is my first post. I'm looking forward to contributing in this great community!
Bookmarks