I am using this formula
= HYPERLINK("[MyFle.xlsm]" & F5 & "!A1","Link")
The above operation works very well. It will not pass through a query. I havemultiple sheets with identical tables on them. From each sheet I am trying topass the above link so my query will link back to the sheet that the table ison.
I understand a pivot table would provide thisfunctionality but I am on a’’ let’s say pretty restricted system and pivottables do not work.
I am able to get all data I need but want the abovefunctionality.
Thanks,
Dave