second and hopefully last question for now. Is there a way to the following:
I have a dropdown list with names of tabs of the excel file and have a table on the same tab with data in it linked to the currently set name from the dropdown. I would like excel to do the following, when choosing another name from the dropdown (name of other tab) I would like that excel does a find and replace on this tab so that the data in my table now become linked to this newly selected tab from the dropdown.
Example, in tab 1 I have data linked to tab 2 (dropdown set to 2) From the dropdown in Tab 1 I would like to select 3 and have the data become linked to tab 3 instead of tab 2.
Do you think it is possible or is there an easier way perhaps? I now I could just do a find and replace without having to go through a dropdown, however the people using this file may not even know how to do that:)