Hi
Too vague. You say there are two sheets, but then your problem seems to
only apply to one sheet, and we don't know which!
You say "Then look at Product Range". Look at how? Look at where?? Is a
decision to be made based on a value???

regards
Paul