find xact text in 2 sheet n update the result

June 24, 2011 at 02:47:00
Specs: Windows XP
I have Response XMl Schema from 2 different environment of an application in sheet1 and sheet2 on the msexcel . I have a collection of xml tags in sheet3.
I want to write a macro which do the following
(e.g)
<State>TN</State>
<Country>INDIA</Country>
............
etc.......
1. I have to select the xml tag(Country) from Column A of sheet3 .
2. goto sheet 1 and search whether the Tag is displayed in the Response XMl Schema for the 1st environment.
3. then goto sheet 2 and search whether the Tag is displayed in the Response XMl Schema for the 2nd environment.
4. update the status (i.e where tag found or not found) in Column B of sheet3.
Can anyone please help me out to write a macro to perform the above activity.

Thanks.


See More: find xact text in 2 sheet n update the result

Report •

#1
June 24, 2011 at 03:28:12
I'm not clear on what you are trying to to do.

1. I have to select the xml tag(Country) from Column A of sheet3 .

What do you mean by "select the tag"? In Excel to "select" something means to click in the cell or on an object or click and drag to highlight ("select") a range of cells.

4. update the status (i.e where tag found or not found) in Column B of sheet3.

Do you mean that you need to put an X or a Yes or something like that in Sheet3 Column B if the value in Sheet3 Column A is found in a specific column in either Sheet1 or Sheet2?

Couldn't a VLOOKUP statement do that for you?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question