If formula result is false, how do I auto-delete that rows?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some formulas on sheet one that make the rows flow to one of the other
sheets - depending on the result of the formula. My problem is that on sheet
two, I have 3 rows with data, then 8 blank rows, then another row of data,
etc... How do I automatically remove the "False" rows from subsequent
sheets?

Appreciate the assistance!

John
 
Select the range, press F5, click special, select blanks, press Ctrl and -
(minus/hyphen), select entire row, press enter or click OK
 
You must log in or register to reply here.

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

Dependent drop down dynamic range formula, off sheet. 7
using the =page! feature to transpose a row to column 0
Excel Help to copy information from one row at a time to another sheet 1
Losing rows that reference data from another worsheet 1
COUNT rows on external sheet if between date range 3
Excel IF Formulas 2
Auto Change Formulas - Please Help. 2
Applying formula to variable number of rows 5

Back
Top