Forum Discussion
check boxes to insert tables below with macro
Here is a possible solution. Your description left me guessing a bit at what ultimately you're going to be doing with this. So I made some assumptions, and based on those made some changes to the way your data are organized. Specifically, I created a combined database, basing this on the assumption that all of your different tables actually use the same headers, or a subset of them. SepB, for example, uses two fewer than SepA, but otherwise appeared the same.
I then created a DropDown box (highlighted in Yellow) instead of your check boxes. Pick either SepA or SepB and you'll see what happens.
That pulling of the requested table is accomplished using the FILTER function. Something to note, though, is that it works precisely because it calls on a single database, one that consolidates what you had as two separate tabs.
This may or may not be a solution that fits your need, but it's a demonstration of what's possible without having to resort to VBA. If it (cleaned up) can't work....i.e., if the assumptions I made don't hold true for all of your situation...please come back with a more complete description, and we'll see then if I or somebody else here can help.