Excel 2003 – Copy Data Found By SUMPRODUCT To Another Sheet?

Excel 2003 – I Need To Copy the Data Identified By SUMPRODUCT To Another Sheet?

Hi There.

Please could someone point me in the right direction to solve a problem I’m having?

In my workbook Sheet 1 contains a dynamic range from A1 to J880. (Capacity is 65536).

Sheet 2 has different SUMPRODUCT formulae to count the occurrences in the range which fulfil certain criteria, sometimes with as many as 4 conditions.

SUMPRODUCT returns an accurate number of occurrences but I need a function/macro/formula to take things a step further.

Is there a way (without autofilter or pivot table) to automatically copy all the data in the rows identified in the range by the SUMPRODUCT formula into a separate list on Sheet 2?

I know how to sort and autofilter the data manually but I’m designing the workbook to simplify and automate the process as much as possible for people who hate ‘having to use’ computers (strange people that they are!).

Many Thanks. Gordon.