Lookup and Change Values
 

I have two columns of data with about ~100 rows (plant names and type of
plant). This information comes from a dump file from a website.
Unfortunately the type of plant for 11 of the plants is not what I need it
to be so I need to change the dump file information to another type of plant.
For example, in the dump file plant #44 is listed as an electronics plant
but it is a technical center. I normally just manually change them but I
would like to automate this. I could do this in VBA coding or formula if it
is possible.

Any help would be appreciated.

Thanks.

Lookup and Change Values
 

Why not use Replace from the Edit menu?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Jeff Gross" wrote in message ...
I have two columns of data with about ~100 rows (plant names and type of
plant). This information comes from a dump file from a website.
Unfortunately the type of plant for 11 of the plants is not what I need it
to be so I need to change the dump file information to another type of plant.
For example, in the dump file plant #44 is listed as an electronics plant
but it is a technical center. I normally just manually change them but I
would like to automate this. I could do this in VBA coding or formula if it
is possible.

Any help would be appreciated.

Thanks.

Lookup and Change Values
 

As far as I know, using Find/Replace will replace only what you look for and
not an adjacent column.

The plant type is not unique - in other words, there are many plants of each
type.

Jeff

"Jim Cone" wrote:


Why not use Replace from the Edit menu?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Jeff Gross" wrote in message ...
I have two columns of data with about ~100 rows (plant names and type of
plant). This information comes from a dump file from a website.
Unfortunately the type of plant for 11 of the plants is not what I need it
to be so I need to change the dump file information to another type of plant.
For example, in the dump file plant #44 is listed as an electronics plant
but it is a technical center. I normally just manually change them but I
would like to automate this. I could do this in VBA coding or formula if it
is possible.

Any help would be appreciated.

Thanks.

Lookup and Change Values
 

Apply Autofilter to the plant type column, and select Electronics
Plant from the filter pull-down. In the first visible cell change this
to Technical Center and change the adjacent cell to suit. Then
highlight both of these cells, click <copy and then paste them over
the other visible cells. Then select All from the filter pull-down.

Hope this helps.

Pete

On Mar 20, 2:47*pm, Jeff Gross
wrote:
As far as I know, using Find/Replace will replace only what you look for and
not an adjacent column.

The plant type is not unique - in other words, there are many plants of each
type.

Jeff



"Jim Cone" wrote:

Why not use Replace from the Edit menu?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Jeff Gross" wrote in ...
I have two columns of data with about ~100 rows (plant names and type of
plant). *This information comes from a dump file from a website.
Unfortunately the type of plant for 11 of the plants is not what I need it
to be so I need to change the dump file information to another type of plant.
*For example, in the dump file plant #44 is listed as an electronics plant
but it is a technical center. *I normally just manually change them but I
would like to automate this. *I could do this in VBA coding or formula if it
is possible.

Any help would be appreciated.

Thanks.- Hide quoted text -

- Show quoted text -