Excel VBA, locate data with sub tables, repeated rows/column headings
Posted on 2012-03-13
I have the following tables in a report:
What is the best way to cherry pick the data I need to store in a variable in VBA?
For example, Barry's Work Phone or Charles' Home Address
Also, these are in the middle of the spreadsheet, they don't start on A1, so need something purely driven by table name (Adam), and row / column name (Work,Phone).