I am rephrasing your problem
sheet2 is your main sheet containing in col A and B the model number and no. available ( 0 to any value).
if the number available is 0 you want in sheet against the particular model no. you want the entry "no" is made in col. B of that sheet
all model numbers which are available (that is "yes" in sheet 1 should be copied in sheet 3.
I wonder what is the need of sheet1.
Keep your original database safe.
now run this macro "test" in which is embedded the other macro test1.
you can modify the macro(s).
I am attaching my sample file "royUK" so that you can understand the logic of the macros and modify them to suit you.The sheets are AFTER running the macro "test". you can again rerun the macro "test" only.
Bookmarks