|Nope...doesn't make sense to me.|
Keep in mind that we can't see your spreadsheet from where we're sitting, so you have to be very specific in telling us what you are trying to do.
Better examples of your data would help also.
Please click on the following line and read the instructions found via that link before posting any example data.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.