I have a worksheet where data is loaded on Template.
The Template will have data on every Column except dates (Columns M,N)
If there is a date...
I need it to loop until an empty M Column and copy paste rows: B, C, G, M, N to a new sheet.
However,
If worksheet "Entire" exists it would only reference that worksheet and do the same but not copy anything from Template.
I tried using a formula to obtain this info. However, with the number of rows/columns it made my book too data heavy.
The Template will have data on every Column except dates (Columns M,N)
If there is a date...
I need it to loop until an empty M Column and copy paste rows: B, C, G, M, N to a new sheet.
However,
If worksheet "Entire" exists it would only reference that worksheet and do the same but not copy anything from Template.
I tried using a formula to obtain this info. However, with the number of rows/columns it made my book too data heavy.