count occupied cells, but put count total in different worksheet

Hello,

I need a macros to count the # of occupied cells in a worksheet but be able to run it from a different worksheet.

I would like it to count how many occupied cells there are starting from row 2,column A (and extending to E) in "Sheet1".
But!
I would like to be able to assign this macros to a button in cell B5 of a worksheet named "MTBR" , and have the total count populate cell B6 in MTBR.

Hope someone can help, I know how to assign a button to a macro.

thanks!

Nope i could use a count formula, i'm just not sure how i would do that. I have three lists in my worksheet "sheet1" they occupy columns A,C,E (so B and D are empty). And this list could get bigger so i would need the formula to be prepared for that and change as new entries were added. I tried just a simple "=COUNT(A$2:E$300), but it gave me zero.
thanks

You can just do a normal count. Set the range to be the entire column, like =COUNT(A:A). that way, as the column grows, it will continue to count. The count function does not count blank cells.

how do I get it to not count row one, but then all the rest? because my data is columns A:E but the first row is just titles, and my list consists of a letter than a 4 digit number so "COUNT" doesn't work, and "COUNTA" adds in the first row that I don't want added.

thanks

Subtract 1 from the COUNTA().
Note that the COUNTA() will count ALL occupied cells, including those with formulas returning "" values. If you have those and you don't want them counted you can do a count with COUNTIF(range,"?*").