Hi Susan,

welcome to the forum.

Form as in VBA User form? Or Form as in a layout on a sheet?

Your problem will be a lot easier to understand and solve if you supply a small data sample in a workbook. You can upload a file by clicking "Go Advanced" below and then the paper clip icon. Make sure to supply a "before" and "after" scenario and explain the logic that leads to the solution.

cheers