Insert new sheets...

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top