This same issue has been addressed repeatedly in this forum. I'm not having any trouble with the simple copy and paste macro. I am, however, having problems defining my ranges in a simple way.

I track my daily orders and the tips I get from those orders in a monthly sheet. I would like those daily entries to copy and paste to a sheet with running totals. I have attached an example:

Tips example.xlsx

What I can't get my code to do:
-Copy only the cells containing values for each of the days in a given month.
-Paste those values to the first blank row in the "Orders vs Tips" sheet.

Any advice?