Thread: 6 cells into 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Duncan_J Duncan_J is offline
external usenet poster
 
Posts: 46
Default 6 cells into 1

Hi folks...
I'm going to try this again...
M N O P Q R S
1 Start Start
2 Run Run
3 Finish Finish
4 Start Start
5 Finish Finish
6 Done Done
ect...

I do a vlookup for one at a time Coulmns M-R and only 1 out of the 6 lookups
will find data. I need to disregard the blank cells and copy the data to of
the populated cells to coulmn S
Thanks for the help,
DJ