Re: Concatenating two databases from the same Excel Spreadsheet
Dec 3, 2009 1:42 PM(1001 views)
I was reminded of the fact that Data Table(1) corresponds to the most recent data table, Data Table(2) to the next most recent and so on. This makes my previously posted snippet work correctly only if there are no other open tables when it is run. Here is one that should work correctly even if there are other tables open. It still requires work to make it robust to other possibilities.