|re: "Any suggestions?"|
Sure...I suggest that you describe the layout of your spreadhseet and post the code that you are using so we have a better idea of what you're working with.
Please read the How To referenced in my signature line before posting any data or code.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.