Hi everyone!
I'd like to create a macro to find the number of times a bunch of records within tables appear in subsequent sheets of the workbook and then be able to divide it by the total number of sheets. The reason for doing so is to be able to calculate the percentage that these records appear within the workbook. However, I'd like to eliminate the first 3 sheets as these are templates for the remaining sheets. So from the 4th sheet onwards I'd like to be abe to count to the last sheet. The records are within 3 different tables on a single sheet. From the 4th sheet onward, all sheets have the same layout/template (if it makes it easier to code in anyway). Any help would be very much appreciated! Thanks!
Bookmarks