Find and replace list of data

[shrinivasmj]

Need vb or macro

hi i have list of data in sheet 1 in A Column


[TABLE="width: 379"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Painting & Decorating Supplies[/TD]
[/TR]
[TR]
[TD]Paint & Varnish Stripping[/TD]
[/TR]
[TR]
[TD]Outer Holm of Skaw[/TD]
[/TR]
[TR]
[TD]Outdoor Clothing & Equipment[/TD]
[/TR]
[TR]
[TD]Otis Air National Guard[/TD]
[/TR]
[TR]
[TD]Otis A F B[/TD]
[/TR]
[TR]
[TD]Orton On The Hill[/TD]
[/TR]
[TR]
[TD]Orkney Isl And S[/TD]
[/TR]
[TR]
[TD]Opticians - Ophthalmic (Optometrists)[/TD]
[/TR]
[TR]
[TD]Optical Goods - Wholesale[/TD]
[/TR]
[TR]
[TD]Optical Goods - Mnfrs[/TD]
[/TR]
[TR]
[TD]Oldbury On The Hill[/TD]
[/TR]
[TR]
[TD]Old Man of Hoy[/TD]
[/TR]
</tbody>[/TABLE]
Tyne and Wear[TABLE="width: 379"]
<colgroup><col></colgroup><tbody>[TR]

[/TR]
[TR]
[TD]Need to find the word in Sheet 2 ,A Column and Replace With # Before the word and after the word

EG-Tyne and Wear will replace like first data shown here

[TABLE="width: 1369"]
<colgroup><col></colgroup><tbody>[TR]
[TD] A19 Film & Video Mulgrave Ter N/A N/A Gateshead #Tyne and Wear# NE8 1PQ North East Office & Administration 2-5 - Film Studios & Production Services 9
[/TD]
[/TR]
[TR]
[TD] A19 Fleet Driver Development The Lodge Sandy Lane N/A Billingham Cleveland TS22 5NA North East Head Office 1 3-9 Driving Schools [/TD]
[/TR]
[TR]
[TD] A19 Mini Mix Teesside Ltd Billingham Reach Industrial Estate Haverton Hill Road N/A Billingham Cleveland TS23 1PX North East Factories & Manufacturing 2-5 3-9 Concrete & Mortar Ready Mixed [/TD]
[/TR]
[TR]
[TD] A19 Mini Mix Teesside Ltd Billingham Reach Industrial Estate Haverton Hill Road N/A Billingham Cleveland TS23 1PX North East Factories & Manufacturing 2-5 3-9 Concrete & Mortar Ready Mixed [/TD]
[/TR]
[TR]
[TD] A19 Pools & Spas 9 Lister Road N/A North West Industrial Estate Peterlee County Durham SR8 2RB North East Head Office 2-5 LT 3 Hot Tubs Spas And Whirlpools 5[/TD]
[/TR]
[TR]
[TD] A19 Pools & Spas 2 South Side Retail Pk Portrack Lane N/A Stockton-on-Tees Cleveland TS18 2TA North East Office & Administration 6-10 LT 3 Swimming Pool Contractors, Repairers & Service [/TD]
[/TR]
[TR]
[TD] A19 Smart Car 2 Hardwick Court N/A Blackhall Colliery Hartlepool Cleveland TS27 4FB North East Workshop & Repair Centres 2-5 LT 3 Car Valet Services 5[/TD]
[/TR]
[TR]
[TD] A19 Taxi Insurance Ferndale House 70-71 North Road N/A Boldon Colliery Tyne and Wear NE35 9AX North East Head Office 11-25 10-19 Insurance Brokers 6[/TD]
[/TR]
[TR]
[TD] A19 Taxi Insurance Ferndale House 70-71 North Road N/A Boldon Colliery Tyne and Wear NE35 9AX North East Head Office 11-25 10-19 Insurance Brokers 6[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[niladri2005]

i am sorry but the question is not clear to me. Would you please what exactly do you want?. Do you have any data in sheet2?

 

[shrinivasmj]

list are in sheet 1 A COLUMN
[TABLE="class: cms_table, width: 379"]

<tbody>[TR]
[TD]Painting & Decorating Supplies[/TD]
[/TR]
[TR]
[TD]Paint & Varnish Stripping[/TD]
[/TR]
[TR]
[TD]Outer Holm of Skaw[/TD]
[/TR]
[TR]
[TD]Outdoor Clothing & Equipment[/TD]
[/TR]
[TR]
[TD]Otis Air National Guard[/TD]
[/TR]
[TR]
[TD]Otis A F B[/TD]
[/TR]
[TR]
[TD]Orton On The Hill[/TD]
[/TR]
[TR]
[TD]Orkney Isl And S[/TD]
[/TR]
</tbody>
[/TABLE]


Tyne and Wear

and sheet 2 as the data

[TABLE="class: cms_table, width: 1369"]

<tbody>[TR]
[TD]A19 Film & Video Mulgrave Ter N/A N/A Gateshead #Tyne and Wear# NE8 1PQ North East Office & Administration 2-5 - Film Studios & Production Services 9[/TD]
[/TR]
[TR]
[TD] A19 Fleet Driver Development The Lodge Sandy Lane N/A Billingham Cleveland TS22 5NA North East Head Office 1 3-9 Driving Schools[/TD]
[/TR]
[TR]
[TD] A19 Mini Mix Teesside Ltd Billingham Reach Industrial Estate Haverton Hill Road N/A Billingham Cleveland TS23 1PX North East Factories & Manufacturing 2-5 3-9 Concrete & Mortar Ready Mixed[/TD]
[/TR]
[TR]
[TD] A19 Mini Mix Teesside Ltd Billingham Reach Industrial Estate Haverton Hill Road N/A Billingham Cleveland TS23 1PX North East Factories & Manufacturing 2-5 3-9 Concrete & Mortar Ready Mixed[/TD]
[/TR]
[TR]
[TD] A19 Pools & Spas 9 Lister Road N/A North West Industrial Estate Peterlee County Durham SR8 2RB North East Head Office 2-5 LT 3 Hot Tubs Spas And Whirlpools 5[/TD]
[/TR]
[TR]
[TD] A19 Pools & Spas 2 South Side Retail Pk Portrack Lane N/A Stockton-on-Tees Cleveland TS18 2TA North East Office & Administration 6-10 LT 3 Swimming Pool Contractors, Repairers & Service[/TD]
[/TR]
[TR]
[TD] A19 Smart Car 2 Hardwick Court N/A Blackhall Colliery Hartlepool Cleveland TS27 4FB North East Workshop & Repair Centres 2-5 LT 3 Car Valet Services 5[/TD]
[/TR]
[TR]
[TD] A19 Taxi Insurance Ferndale House 70-71 North Road N/A Boldon Colliery Tyne and Wear NE35 9AX North East Head Office 11-25 10-19 Insurance Brokers 6[/TD]
[/TR]
[TR]
[TD] A19 Taxi Insurance Ferndale House 70-71 North Road N/A Boldon Colliery Tyne and Wear NE35 9AX North [/TD]
[/TR]
</tbody>
[/TABLE]