Hi

I'm way out of my Excel depth so i thought I would ask the experts. I want to create a workbook for controlling an exhibition with three monthly changeovers. So, there will be a mastersheet at the start with a column for when an item goes into the show, lets call it column A, and column B will be when it will be taken out of the show. Then there will be all of these following worksheets for the individual changeovers, titled January 2013, March 2013, June 2013, September 2013 etc etc Now can excel populate what is going to be in the show from Column A and B and use that info to populate the worksheets for the particular dates? So, if an item enters the show in March 2013 and is removed in September 2013 the row with all of the info about that item will appear in the three worksheets titled March 2013, June 2013 and September 2013.
sort of, copy this row to this worksheet; If date in column A equal or greater than worksheet titled date, unless it is greater than Column B.
I hope that makes sense?

Thank you