I am developing a spreadsheet to control a wedding decorating hiring business. Example they book out 120 table cloths from the 1 Oct to the 5 Oct. The spreadsheet must remove these items from stock for that period so that if a search or stock level query is performed on available table cloths 120 will not be available between those two dates.
I need help on the specific date formula to use or the combination of database query formulas to use.
Thanks
Kevin
Attached is a sample Spread Sheet. 3 sheet Tabs. Opening Stock, Booking, Query
Its the query that I need help on. I want to be able to change the query date and run the macro that will show my available stock on that date.
Bookmarks