“that I need to combine on the Output sheet.” Samples of correct cells in col F of output sheet____________?
Don Guillett SalesAid Software dguille...@gmail.com From: dguillett1 Sent: Thursday, November 10, 2011 1:53 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits Confusing to me. The easiest way to delete the rows with 1 is to filter and delete. Are you saying that for sheet 1 and sheet 2 you want to delete the rows with 1 in col c and then combine? If so, why not combine and then run a filter delete on the combined sheet. Do you need to keep the source sheets or delete? Don Guillett SalesAid Software dguille...@gmail.com From: Urghhh Sent: Thursday, November 10, 2011 1:11 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits Hello I need to combine data from to different sheets to one sample sheet. In the Example I have one macro deleting all rows in the "Paste Sheet 1" where the value in col C = 1 I now need a way to generate the "Output" sheet My problem is in the " col on the Output sheet. As you can see is the search key "Paste sheet 1" col A and the lookup in "Paste Sheet 2" col D. In the first line the value 2159 gives 4 hit in "Paste Sheet 2" that I need to combine on the Output sheet. Any suggestions? Thanks all -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
