I have an excel file:
work sheet1 contains following numbers
==========================
1 1001
31 800
2 5000
17 201
8 2
5 4305

work sheet 2 contains the following numbers
=============================
2 201 800 1001 4305 5000
1
2
5
8
17
31

I want the macro to put x in the proper locations in sheet2
by referring to sheet 1

Output of the macro looks something like this
======================================
2 201 800 1001 4305 5000
1 x
2 x
5 x
8 x
17 x
31 x

Thanks for all the help