Hi all
Thank to repliers
Now I am writing again without attacments .

Need a macro to check which products have not ordered for eac
branch.

I have a list of branches in column "A" (10 rows) and products tha
they have ordered in column "B".
There is a list of all products in other sheet (20 rows).

Since the every branch have their orders contains just a part of th
products list,

this macro have to open rows in column A , Insert the missing product
and branch code ,
and have to write "not ord" for those items in column C .

any help will appreciate
Thanks again ,

lshavi

--
lshavi
-----------------------------------------------------------------------
lshavit's Profile: http://www.excelforum.com/member.php...fo&userid=1462
View this thread: http://www.excelforum.com/showthread.php?threadid=27359