View Single Post
  #1   Report Post  
1stpope
 
Posts: n/a
Default is there someway to select what i have "found"?

hello,
is there a way to select multiple cells based on the text contained within
them?
i can use "find" to find what i am looking for, but i can not seem to select
all of these cells. i have taken a crash course in naming, formulas, go to..,
filtering and anything else i can try, but nothing seems to work. or it could
just be my brain.

Alternately, is there a way to easily reorganize one huge long column into
multiple columns while maintaining the coherence of the data groups. IE the
long column contains sets of text in several cells like a1 through a6, then
the next set is a8 through a12, etc. But i need to have these groups in
columns next to each other.
i am just learning about macros and such, so i do not know if i can
accomplish anything to advanced.
do not know if i am making sense with this as i am fairly loopy right now.
any help would be appreciated.
thnx