Is there a way to Macro copy and paste to the next empty row on a sheet?

[kingdom11]

I have a Workbook where I have Calculations on one sheet and SavedData on another sheet. I created a Macro that copies the data I need on the Calculations sheet and paste them in the next empty row on the saved data sheet. The issue I have is it saves all all the blank rows associated with it. I want a way to ignore that so it doesn't get messy when creating to a table.

I have the macro currently pasting the data as special values which I need.

Please Login or Register  to view this content.

[AC PORTA VIA]

can you filter column G for all but not blanks before you copy and paste?

[kingdom11]

I tried that but if I ever need to delete any rows, it becomes all wonky due to the table/filter registering the blanks.

[AC PORTA VIA]

filter copy paste and unfilter again