Hi All,

This is my first post on a help site so hopefully its not to painful for you
Background info: Smash repair industry, spreadsheet is used to enter all vehicle info, job costs, customer details etc.

Spreadsheet will contain all vehicles repaired for that year. Another worksheet is created by copying from the main list to form a weekly sheet i.e. all vehicles coming in for that week only, including vehicles not completed from previous week.

All vehicles have an "InDay" and "OutDay", which are 2 seperate dates in seperate columns.

How can i apply a filter so only vehicles which are coming in on DateXXXX and going out on DateXXXX are shown.

please see the worksheet attached which may...