Countblank and paste in 2nd worksheet

[brent_milne]

I am trying to count the number of blank cells on worksheet 1 and paste that value into B16 on worksheet 2. I'm just having problems setting up the range to check as it will be a different amount of rows every time so I need to find the last row and then count all blank cells to paste into B16. It is probably a simple solution but being new at this I am probably trying to over think it. Thanks for any help.

[Bob1980]

If there is an adjacent column with values inside of it, then you can use an offset/match Combo to define the range within an COUNTIF formula. The offset/match combo will allow for a dynamic range.

Please Login or Register  to view this content.

if this isn't accurate, or if you need more assistance, can you attache a sample copy of the spreadsheet?

[brent_milne]

I have attached a sample copy to make it a little clearer. I need a macro to count all the blank cells in Column B from the first sheet (Import Projects Here) and then paste that total into B16 on the second sheet (Project_Totals). The range in Column B will always be changing so I need to find the last row then count the total blank cells.