|Your request is not clear to me.|
I think short example of your data might help. Please click on the last line of my post and read the instructions on how to post example data in this forum. Then post an example of your data and headings so we can see what we are working with. Please ensure that you use column letters and row numbers as shown in the instructions.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.