VBA Code Copy Non Blank Cells

Job ID: 33346679

Budget: $10 – $30 AUD

VBA Copy and paste within same workbook non blank cells. Current VBA pastes full range.
Resulting in blank cells cells between the next time the VBA is run