View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
geither geither is offline
external usenet poster
 
Posts: 1
Default Eliminate Blank Rown in a List - Then Create New List

Hello,

Suppose I have the following:

A B C
1 John WD -100
2
3 Bob WD -200

This is a ist of items with 3 rows, but 1 row is blank. I want to keep row
2 there, because it is driven by formulae. I need to create a new list which
eliminates the blank row (#2).

Any ideas?

Thanks,

Mike