I have sheet1 that has 7 columns that belong to each store and i have 3
warehouses and each store belongs to one of those warehouses. I have the
sheet set up so that the store number goes in (merged) a1-d1, h1-k1,etc and
the warehouse goes in (merged) e1-g1, l1-n1, etc. In row 2 I have a2-g2,
e2-n2, etc (merged) equalling the warehouse number.

Daily orders are placed in rows 3-100. My object is to be able to filter
the spreadsheet so that I am only looking at one warehouse's orders at a time
(the orders are put in randomly as they come in. I want to run the filter
sideways so that columns that have warehouse 3 showing in row 2 are the only
ones showing.

Help - i really have NO experience with filters!!! :)