Hi irisha
Getting excel to do what you want via a macro is easy enough but you haven't said what you actually want. Return specific columns, which ones? 3 of the statuses, which ones? Do all the cells contain the word Value? If so the cells are not numeric, they're all considered text. If you explain it clearly & show exactly what you need you'll be more likely to get the help you need. I can have a look tomorrow & if I can't finish it, it'll be next weekend before I can look at it again.
Cheers
Phil
|