View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dwight Trumbower Dwight Trumbower is offline
external usenet poster
 
Posts: 6
Default Filter blanks and populate with a series

How does one filter on blanks and populate with a series?

I'm trying to replace all blanks in a column with TA1..TA2..TA3..etc. When
in filter mode, excel doesn't let you copy just to the filtered rows. I've
tried a few things from google, but I can't get anything to work.

Thanks

Dwight