Thread: Finding Blanks in list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jahsonn Jahsonn is offline
external usenet poster
  
Posts: 9
Default Finding Blanks in list
I have a list of data as such.

112526 name
254412 name
125421 name
254412 name
254412

The first column will always have a value in it but the
second and third columns may not have values in them. Is
it possible to have a macro run down the list and any
items which it doesnt have values in columns b and c to
copy to another sheet?


Reply With QuoteReply With Quote