I am trying to pull specific data from one worksheet and have it displayed in
another using a formula. Specifically, I have a worksheet setup with
products identified in column A and sales dates in column B, among other
information. I then have separate worksheets for each year (2007-2010). If
a product is indicated to be sold during 2007 in column B, i need it to show
on the separate year worksheet without rows between each product pulled to
the new worksheet (i.e. the list needs to be continuous down the column
without rows between). Is this possible through a formula?