{"id":411,"date":"2021-09-03T20:00:30","date_gmt":"2021-09-03T20:00:30","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/office-excel-2003-copy-data-found-by-sumproduct-to-another-sheet-16668-html"},"modified":"2021-09-03T20:00:30","modified_gmt":"2021-09-03T20:00:30","slug":"office-excel-2003-copy-data-found-by-sumproduct-to-another-sheet-16668-html","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-2003-copy-data-found-by-sumproduct-to-another-sheet\/16668.html","title":{"rendered":"Excel 2003 &#8211; Copy Data Found By SUMPRODUCT To Another Sheet?"},"content":{"rendered":"<td>\n<p>Excel 2003 &#8211; I Need To Copy the Data Identified By SUMPRODUCT To Another Sheet?<\/p>\n<p>Hi There.<\/p>\n<p>Please could someone point me in the right direction to solve a problem I&#8217;m having?<\/p>\n<p>In my workbook Sheet 1 contains a dynamic range from A1 to J880. (Capacity is 65536).<\/p>\n<p>Sheet 2 has different SUMPRODUCT formulae to count the occurrences in the range which fulfil certain criteria, sometimes with as many as 4 conditions. <\/p>\n<p>SUMPRODUCT returns an accurate number of occurrences but I need a function\/macro\/formula to take things a step further.<\/p>\n<p> 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?<\/p>\n<p> I know how to sort and autofilter the data manually but I&#8217;m designing the workbook to simplify and automate the process as much as possible for people who hate &#8216;having to use&#8217; computers (strange people that they are!).<\/p>\n<p> Many Thanks. Gordon.<\/p>\n<\/td>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","meta":{"inline_featured_image":false,"iawp_total_views":53},"question-category":[],"question_tags":[],"class_list":["post-411","question","type-question","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/411","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=411"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=411"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=411"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}