Hi,
I have a cell which is a drop down list based on certain values (Table Names).
These table are on one worksheet all with their own format (header rows etc), these are consistent formats however (if it helps). The only difference is the data contained within each table.
At the moment it's very cluttered. what I was hopnig to do was create a drop down list and when a table is selected, cells on spreadsheet will populate with the data from that table.
I've tried H/VLookup but cannot get it to play ball.
Is my problem the fact that my tables are spread out and not in one defined range?
Thanks
I have a cell which is a drop down list based on certain values (Table Names).
These table are on one worksheet all with their own format (header rows etc), these are consistent formats however (if it helps). The only difference is the data contained within each table.
At the moment it's very cluttered. what I was hopnig to do was create a drop down list and when a table is selected, cells on spreadsheet will populate with the data from that table.
I've tried H/VLookup but cannot get it to play ball.
Is my problem the fact that my tables are spread out and not in one defined range?
Thanks