Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mark if cells match on 2 sheets
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mark certain cells | Excel Worksheet Functions | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Graph on each sheet when I mark same cells on multiple sheets | Excel Discussion (Misc queries) | |||
Copy cell values if cells match on two diff sheets | Excel Programming | |||
Mark files and sheets for identification | Excel Programming |