Copy From To Macro Need Help With Adjustment

Hi

This macro works fine for one filtered number i.e. it will copy all of the rows fom the download sheet where there is a number in column A which is equal to 60134000.

The problem I have is that some customers have 10 + account numbers and after it has copied all of the 60134000 numbers from the download sheet to the Cust1 Sheet I want it to drop down a row on the Cust1 sheet and copy all of the 280116000 numbers underneath that and then the next and the next up to a maxium of say ten numbers.

The start point on both sheets is A4.

Please Login or Register  to view this content.