Move data from one database to many sheets

Originally Posted by darknessheir

This works great, now if only i can remember the formula to add the all together.

What do you mean, exactly? If you mean to add a total into the boxes at the bottom of each selection, then this should do the trick.

=COUNTA(B6:B22) - COUNTIF(B6:B22,"")