I have a dropdown list on page 1, with numbers from 1 to 10. I have the
dropdown linked to the cell underneath (eg A1). If the number in the dropdown
(and cell A1) is greater than 1, I want it to go to a cell in sheet 2. I have
tried the €˜IF statement but I am obviously doing something wrong. Your help
would be greatly appreciated.

Lynda