I have an add-in I have developed with some VBA code and 2 tables on different sheets. TableA is self contained (i.e. only relevant to the VBA code w/i the UDF in the Add-In). TableB is a Holiday table that I would like to distribute via the Add-In so other using the Add-In need not maintain their own holiday table. So I need to be able to reference the Holiday table within the Add-In by workbooks that have the Add-In installed. But when I go to reference TableB in a workbook that has the Add-In installed excel doesn't seem to recognize TableB.
I'm hoping this is possible but afraid Excel may not have this ability. I googled a few phrases but can't seem to find any postings that say this can't be done nor that it can be done. Anyone have any knowledge of this and if it can't be done anyone have any good solutions to distributing data (i.e. holiday listing for use in the WorkDay function) via an Add-In.
Thanks in advance.
I'm hoping this is possible but afraid Excel may not have this ability. I googled a few phrases but can't seem to find any postings that say this can't be done nor that it can be done. Anyone have any knowledge of this and if it can't be done anyone have any good solutions to distributing data (i.e. holiday listing for use in the WorkDay function) via an Add-In.
Thanks in advance.