ExcelBanter - Copy rows onto existing sheet / start a new sheet if full

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Copy rows onto existing sheet / start a new sheet if full (https://www.excelbanter.com/excel-programming/401902-copy-rows-onto-existing-sheet-start-new-sheet-if-full.html)

mg_sv_r

Copy rows onto existing sheet / start a new sheet if full

Hi

Could anyone help me with a macro that will copy all rows of one worksheet A
onto worksheet B but if worksheet B becomes full, start a new worksheet
appending a letter or number to the worksheet name?

Thank you in advance for any help.

Regards
John

All times are GMT +1. The time now is 04:22 AM.