Hi all,

I have a 3 sheet workbook where sheet1 displays a summary of the data in sheet2 using sumproduct formula. Sheet3 contains the contents of the dropdownlists that are used by a data input form (called up from a button on sheet1) that writes new records to sheet2 (the data sheet).

This all works fine but to search the data for specific records, I have to go to sheet2 and use the data/filter/autofilter function.

What I'm looking to do is call up a search form from a button on sheet1. The resulting records of the search need to be displayed (copied) at the bottom of sheet1 and deleted when another search is requested.

Hope this makes sense. I've searched the forums under 'search' but can't identify a solution.

Regards

Gary