cdub50
03-08-2007, 03:56 PM
I have this macro I created to look at column B(customer) and check if the selected value in cell B2 is equal to B3 if it is to selects the next cell below and keeps checking to see if the vaule is the same. If they are not the same the macro inserts a blank row and then sums the rows above for that customer and puts the total below look the attatchment
What I need is a macro that will take all of the information for each customer and cut and paste it into a new worksheet depending on the Total value. customers that have Totals that are 0-99 Gigs would have all rows including the total row cut and pasted in a new worksheet called 0-99. for totals that are 100-199 they would be cut and pasted into go into the 100-199 worksheet. I think a case statement would work but not sure how to select the rows. I attached a sample xls file with my macro so you can see what I have done so far. I hope I made sense and Thanks for any help on this I have been at this all day with no success
What I need is a macro that will take all of the information for each customer and cut and paste it into a new worksheet depending on the Total value. customers that have Totals that are 0-99 Gigs would have all rows including the total row cut and pasted in a new worksheet called 0-99. for totals that are 100-199 they would be cut and pasted into go into the 100-199 worksheet. I think a case statement would work but not sure how to select the rows. I attached a sample xls file with my macro so you can see what I have done so far. I hope I made sense and Thanks for any help on this I have been at this all day with no success