Excel 2003-eliminating blank rows in target worksheet

R

Rich D

I am moving some data from Worksheet 1 to Worksheet 2 based on 1 criteria.
So far it is a 1 to 1 transfer. However, if a row doesn't meet the criteria,
a blank row results on the Worksheet 2. How can I eliminate the blank row on
Worksheet 2? The formula I am using is:
=if(Worksheet1!$A5="","",Worksheet!C5). I am putting this in Worksheet 2 and
copying down. Thanks for your usual good help.
 

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

Copying Portions of Data 0
Auto deletion of cell entry in given circumstance 0
how to insert serial numbers to rows? 3
need help in fine-tuning a formula that removes blank cells in a column range 3
Reference to another worksheet cell in a sumproduct formula 1
How to insert new worksheet based on # of rows in a data sourch 2
Deleting blank rows with formulas in them 7
Formula from consecutive rows to alternate rows? 2

Top