Happy Xmas All..........
I have a data dump which is a series of tables, the layout and headers of the tables are fairly fixed however the number of rows in each table is constantly changing. What i would like to do is return the table header, and the average turnaround for each table, preferably without amending the tables. Attached is a sample, these tables marked task C1 task C2 etc are the table headers and in the cell next to Average turnaround is the value i would like to return. I would also like to return the bottom value of each table in column C so at the end it should look like:
Task C1 434 2.52
Task C2 16 3.00
Task C3 10 2.20
Task C4 329 3.24
I do not want to amend or adjust the table as this sheet continues on for 3000 more tables, which is the reason i am looking for a VB lookup type function.
Sheet Attached..
Really appreciate any help or guidence i can get.
Thanks Everyone
Nick
Bookmarks