Hi,
I was wondering if someone could help me. I am doing a report where I have several tables which have a different title for each one. What I would like to do is have a drop down list where I can select the table title and then retrieve the data for this table. I've done the easy bit and made the drop down list and played about with named ranges but I just can't figure out how to do it.
Any advice would be greatful!!!
I was wondering if someone could help me. I am doing a report where I have several tables which have a different title for each one. What I would like to do is have a drop down list where I can select the table title and then retrieve the data for this table. I've done the easy bit and made the drop down list and played about with named ranges but I just can't figure out how to do it.
Any advice would be greatful!!!
