I need a macro to tell me which tools from one worksheet are on order o
another worksheet. Worksheet 'NSN LIST REF' has every tool. Workshee
'ORDER' only has the tools on order.

From what I know the macro should work like this:

Match cell in column F9:F4635 'NSN LIST REF' to cell on 'ORDER' colum
N,
if it matchs and cells in 'ORDER' column AK equals anything other tha
"RCV'D" then put an "O" on worksheet 'NSN LIST REF' column S9:S4635. I
'ORDER' column AK does equal "RCV'D" or is not there at all then leav
all those cells blank on 'NSN LIST REF'.

It should look like this:

'NSN LIST REF'
_Column_F_____/____Column_S_
Screwdriver___/____O
Hammer

'ORDER'
_Column_N_____/____Column_AK_
Screwdriver ___/____209BAGSA
Hammer______/____RCV'D

Since Hammer on 'ORDER' is 'RCV'D" there won't be an "O" on 'NSN LIS
REF'.
If Hammer wasn't on 'ORDER' there shouldn't be anything next to Hamme
on 'NSN LIST REF'

--
Optitro
-----------------------------------------------------------------------
Optitron's Profile: http://www.excelforum.com/member.php...fo&userid=2672
View this thread: http://www.excelforum.com/showthread.php?threadid=56742