Macro to compare Sheet2 values with Sheet1 cells range (combined with Name Manager)

[Manish_Gupta]

Hello guys,

I need help in creating a macro.

There are 2 sheets in the attached file. In Sheet1, the range from column A2 to A12 has been Named as "Yes" through Name Manager and the range from B2 to B8 has been Named as "No" through Name Manager.

I need a Macro which first compare the all values of Column A in Sheet2 with Sheet1 "Yes" Name range and if found then enter the value as Yes in Column B in Sheet2, after this all Sheet1 Column A values should get compare with "No" Name range of Sheet1 and if found then enter the value as No in Column B.

The range in Sheet1 is dynamic that's why we had used Name manager so we do not need enter in to the Macro if the range increased.

Any help will be appreciated.

Thanks
MG

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.