Count the Number of Rows in a Table that Have data

I'm getting back into VBA after about 10 years and working on a dashboard. I have a data table with "x" number of rows, and it grows each day. The column I want may or may not have data. In my Dashboard I want to count and then copy the rows that have data in that column.