Forum Discussion
Consolidate data from multiple tabs using a dynamic formula
I have an online file (not using the desktop version) with multiple tabs named ddmmaa. future tabs will be added with random dates. on each tab i want to get the ranges C30:C80, AB30:AB80 and AG30:AG...
It's difficult to draw up a formula without a sample workbook. If you're using Excel 365 then INDIRECT can be avoided in favor of a function like VSTACK that's capable of handling 3D references.