Next Empty Row

G

gregork

I have a worksheet (sheet 2) set up so it basically duplicates important
entries from sheet 1 in the same workbook.
Sometimes the cells in sheet 1 are blank and consequently I end up with an
empty row(s) in sheet 2. How can I do this so I end up with no empty rows?

regards
gregk
 
M

millsy

gregork said:
*I have a worksheet (sheet 2) set up so it basically duplicates
important
entries from sheet 1 in the same workbook.
Sometimes the cells in sheet 1 are blank and consequently I end up
with an
empty row(s) in sheet 2. How can I do this so I end up with no empty
rows?

regards
gregk *
Click to expand...

From the "Data" menu choose "Autofilter". You can then use this to
filter out blanks.
 
G

Gord Dibben

Gregork

Without more detail on how the sheets are set up, it is difficult to say how
to prevent the blank rows from appearing. I am assuming you have "linked
cells".

After the fact, to get rid of blank rows, select a column on sheet2 and
Edit>Go To>Special>Blanks>OK.

With blanks selected.....Edit>Delete>Entire Row.

Gord Dibben Excel MVP
 
Top