Forum Discussion
Solved
Formula getting data from sheets with different names
Hello, I have a file with 12 different sheets (one for each month) that all have the same format. I’m creating a new sheet with graphics. To feed this graphics, I created a table (on this new sheet) ...
=INDIRECT(ADDRESS(5,COLUMN(),,,CONCATENATE($B$9,23)))You can try this formula which is in cell B5 and copied to the right. The data validation is in cell B9 and the reference list for data validation is in range A9:A20.
=INDIRECT(ADDRESS(5,COLUMN(),,,CONCATENATE($B$9,23)))You can try this formula which is in cell B5 and copied to the right. The data validation is in cell B9 and the reference list for data validation is in range A9:A20.