Find and Replace Question

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Greetings. I am using MS VISTA and Excel 2007 (I am a relative newcomer).

When I search for ("Fine what") a particular word, and click on "Find All,"
all the cells containing this word are listed. This is a very convenient
feature.

I was wondering, though, if this feature could be somehow tweaked (this will
probably involve some programming which I am not able to do) so not only the
word (the value being searched for) but other values in other columns would
appear to the right. In other words, it would be these columns:
Book ... Sheet ... Name ... Cell ... Value ... [Next col.] ... etc.

Why? Well, it would be useful to see if there are any inconsistences in the
value and the next column to the right (which is a translation). Of course I
could sort the sheet, but I was just wondering if my above question is
possible.

If this explanation is unclear, I will be happy to elaborate. Thanks.
 
Sounds like a candidate for autofilter
Data>filter>filter on your col for the criteria>
 
After you click on Find All, press Ctrl+A to select all the cells shown in
the Find All table and then click the Close button. All the found cells will
be selected on your worksheet. You can use them to see what rows to check. I
couldn't find a keystroke combination to extend a disjointed selection, so
if you want to extend the disjointed selection to the entire row (to make it
easier to see which cells to check), you can run this macro immediately
after you do the above...

Sub ExtendSelection()
Selection.EntireRow.Select
End Sub
 
Back
Top