Next Empty Row

  • Thread starter Thread starter gregork
  • Start date Start date
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
 
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.
 
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
 

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

Summary Worksheet. 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Help on Macro to hide empty rows 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copying data to the next blank row 0
Some macros not working on shared workbook 8
Hide/Unhide row VBA 1
Excel Cannot delete empty cells/rows 4

Back
Top