I need help with a macro that already has a lot of action, but needs more. I am attaching a sample. In my sample I need to search column J and clear anything in it that does not begin with an E, if I clear that cell, I also need to clear the corresponding cell in F. this will need to loop thru until there is no more data in C.
Next I need to subtotal the F's based on a change in C and put the result in G on what would be the first line of data for that subset. In my example G2, G6, G9, etc will have the subtotals. (if it is easier and this all goes on a bottom line, I can fill the remaining columns down)
Then I need to use the concatenate function to pull the 2nd character from groups the J cells and also put it on the first line of the subset. Line 2 is what it is supposed to look like.
All this will need to loop thru until there is no more data. Line A, B and C will be full of data until the end.
You will notice there will be some lines where people do not have anything in G or J - this is correct and will happen throughout the spreadsheet.
I know this is a lot to ask, but I know there are some awesome excel people on this forum, so I'm shooting the moon.
THANKS ahead of time for any effort you make on this.