Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

2011-11-11 Thread dguillett1
Should do it ALL. See attached Don Guillett SalesAid Software dguille...@gmail.com From: Urghhh Sent: Friday, November 11, 2011 4:43 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits Yes that's the thing :) Kim --

Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

2011-11-11 Thread Urghhh
Yes that's the thing :) Kim -- 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

Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

2011-11-10 Thread dguillett1
-Macros$$ Combine data from multiple sheets, multiple hits Sorry for the confusion. The Delete part is solved. The problem is the Combine part. When I use the Vlookup, it just return one hit on the Output sheet, but if you look on the "Paste Sheet 2" the first customer (with search cri

Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

2011-11-10 Thread dguillett1
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

Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

2011-11-10 Thread Urghhh
Sorry for the confusion. The Delete part is solved. The problem is the Combine part. When I use the Vlookup, it just return one hit on the Output sheet, but if you look on the "Paste Sheet 2" the first customer (with search criteria 2159) gives 5 hits (order lines in our system). What I need i

Re: $$Excel-Macros$$ Combine data from multiple sheets, multiple hits

2011-11-10 Thread dguillett1
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