Trying to provide a order summary.

Hi all,

NBVC helped me a great deal in creating the below formula,

Please Login or Register  to view this content.

This allows certain columns from a workbook to be 'v looked up' without the user having to vlookup or filter so long as the condition (if true) is met. It works a treat however when the user selects another date in the future it also shows up if the condition is true.

I only want the data to show up once, when the date selected is the same as the date the data was entered on. (Its a stock control system - see attached summary stock re-order sheet).

Has anyone an idea how I can add another condition to the above formula to achieve this?

Sorted... thanks to NBVC and sweep. I'll post the finshed workbook soon. It works well in providing an order inventory for date based information collection.

NBVC - From this thread managed to update the stock re-order formula so it does what I need... we got there in the end....

http://www.excelforum.com/excel-work...ml#post2130902