How can i make the range as a dynamic range so it selects the entire sheet
that has value it.
Example
This month there are 572 rows, but I will add 200 rows this month, I do not
want to select the range again. I was thinking if offset might work, but do
not know the whole formula.

Help would be greatly appreciated.

David