copy from one sheet to another and skip the blank rows

D

Dawn

I have a series of data in rows seperated by 3 blank rows and going down a
good few thousand rows. I am copying it into another worksheet without the
blank rows.

Is there a formula I can put in the second worksheet to look at the next
cell on the first worksheet which is 4 rows from the previous and get the
value?
 
S

Sheeloo

Select the whole range and filter the data on source sheet on any blank col
Press F5, click on Special and select Visible Cells only
Copy and then paste on the other sheet..
 

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

Similar Threads

Deleting blank rows with formulas in them 7
Copy and Paste from one sheet to another 3
copy data from one worksheet and disregard blank cells 6
MACRO COLUMNS, SKIP ROWS 6
Why does the skip blanks (paste special) function not work? 2
Need Macro- Insert rows based on dates and copy info from that row 1
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
cell returning totals of 2 cols+ sending this value to another col 5

Top