Thread: Hide Blank Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dee
 
Posts: n/a
Default Hide Blank Rows

Hi there,

Does this make sense?

Situation: Receive database in client format. I insert a key column,
number it sequentially so that I can put it back in order after manipulating
the data. I then add a formula on each row, example:
=IF(COUNTA(b3:m3)=0,"blank row","")

I then sort by this column to put all "blank row" rows together, copy and
paste values into another worksheet, fill in pricing, etc., then copy the
data back into the original worksheet.

After this, I re-sort by the key column, delete the column with the If
statement above and the delete the key column to put the data back as sent.

Does anyone see a problem with doing it this way? I know I can create a VB
macro, but we are trying to avoid this for various reasons.

Thanks!

--
Thanks!

Dee