J
JayL
All -
I have a rather large spreadsheet and want to divide it by moving pieces to
a new tab (Sheet) in the same workbook.
I would like to scan Column A for 2 empty rows together. Then continue until
there are 2 more empty rows, cut and paste what resides between these rows
to a new sheet and continue down the original sheet until exhausted.
Example:
R1 blank
R2 blank
R3 - R6 data
R7 & 8 blank
R9-20 data
R21 22 blank
R23 - 44 data
Objective: create a new worksheet from R3-R6, another worksheet from R9-R20,
another worksheet from R23-R44
Thanks!
I have a rather large spreadsheet and want to divide it by moving pieces to
a new tab (Sheet) in the same workbook.
I would like to scan Column A for 2 empty rows together. Then continue until
there are 2 more empty rows, cut and paste what resides between these rows
to a new sheet and continue down the original sheet until exhausted.
Example:
R1 blank
R2 blank
R3 - R6 data
R7 & 8 blank
R9-20 data
R21 22 blank
R23 - 44 data
Objective: create a new worksheet from R3-R6, another worksheet from R9-R20,
another worksheet from R23-R44
Thanks!