Hello -

I have a SQL table that I've pulled onto Sheet1. I have another worksheet (Sheet2) that has a data entry field for a sales order number. When this sales order number is entered, I want Excel to find the sales order on the SQL table and pull every part in Column D onto Sheet2 for this sales order, provided Column C of Sheet1 has a 1 or a 7 in it.

I am also going to be pulling the country onto Sheet2. I'd like to be able to have additional worksheets display (or hide certain worksheets) based on the country that is on Sheet2.

Is this possible?

Thank you for your help.