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 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$$ When do my subscribers pay plan

2011-09-23 Thread Urghhh
Hi Sorry :) Here it is. The sheet "from csv" is data copied from the csv file. The sheet "Output idea" is how I want the data to be sorted. The bold numbers is the next delivery month. (I did manage to get thatone by a IF statement) But i need to get the rest of the months to be filled by how

$$Excel-Macros$$ When do my subscribers pay plan

2011-09-23 Thread Urghhh
Hi >From my accounting system (http://www.e-conomic.com/) I get a csv file containing all my subscribers. They are listed like this: Subscribe plan (12x a year, 6x, 4x, 2x, 1x) Start date for next period Amount to pay Here is a couple of examples Every x month, next period start date, Amount 12