Hi Jane,

Welcome to the forum - I have long held the opinion that once you have something in Excel, you can do anything with it - my faith has been shaken upon occasion but not yet shattered

If you can sanitize and attach a sample workbook, I may be able to help you out with a VBA solution