View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rebecca Rebecca is offline
external usenet poster
 
Posts: 106
Default SEARCH AND REPLACE (in Excel 2007, beta)

Greetings. I suppose this should be posted in New Users, which I am, but I'm
sure the solution to my problem will involve some fancy macro programming, so
here goes nothing.

I have four columns: A, B, C, and D in a somewhat large file. What I need
to do is search for a particular word in Col. A, another particular word in
Col. B, and still another particular word in Col. C, all simultaneously, so
this rules out simply using the Search and Replace function. Then once these
three "words" are found, another particular word will be inserted in the same
row in blank Col. D. Perhaps it can be visualized better, thus (and I hope
the formatting doesn't get garbled):

A B C D
xsdfd dvdf 32
eeeff ffere 23
dfdfff 4343 21

If I search on the second row and the three columns, (eeeff ffere 23),
all the rows in the entire file will put a certain word in the blank Col. D
(dkbkk), thus:

A B C D
xsdfd dvdf 32
eeeff ffere 23 dkbkk
dfdfff 4343 21

If it's not too much trouble, could someone please explain in easy English
how this task could be accomplished, or would it involve too complicated
programming?