Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 16th 05, 01:45 AM
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

  #2   Report Post  
Old March 16th 05, 03:27 AM
Kirchberger
 
Posts: n/a
Default

Hi 1stpope,

Try this... If you do a find and click on "Find All", you should see
the dialog expand to show a list of the cells. The first of these will
be highlighted. Scroll down to the end of the list, hold down the Shift
key, and click the last cell listed. You should now see that all your
"found" cells have been selected. At this point you can close the
dialog and dow what you need to do.

As for the column reformatting, that would take some VBA and some
understanding of what defines your groups. It might be complex...

Regards,

Gary



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to select the first blank cell in column A Greegan Excel Worksheet Functions 7 March 13th 05 12:56 PM
In Excel 2000, How do you select the whole of a worksheet (Select. Rascal Excel Discussion (Misc queries) 1 March 5th 05 12:03 AM
In Excel 2000, How do you select the whole of a worksheet (Select. Rascal Excel Discussion (Misc queries) 1 March 4th 05 11:59 PM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM
Select all data, multiple rows George Wilson Excel Discussion (Misc queries) 6 December 5th 04 08:16 PM


All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017