Hi
I am trying to gather figures from a range of multiple data tables.
I have added an example which i hope is clear enough for you, I will try and explain using the actual cells in the attachment.
A4 to A9 reprsents the name of the table to use, marked in yellow
B4 to B9 represents the vertical orange cells in each table.
D2 represents the horizontal cells in each table which will be a validation list check box.
I need the associated figure in the data tables to appear between D4 to D9 which i have manually input as an example.
Thank you
Bookmarks