Macro with Formula to move specific information to new column

I need a macro to move specific information.

I get an excel sheet with W/C Employer: (whatever) entered below the patient it belongs to in column E. This information needs to move into its own column (H) in line with the above patient information so I can use it in a mail merge to word.

The same thing needs to happen with WC injury date listed in column G. It moves to column I. Then delete the row it was moved from so I don't have an empty row.

Sheet 1 is what I get. Sheet 2 is what I need to end up with.

Thank you

redzan,

This work for me, but's it's a lot of code. Let me know if it works.

Please Login or Register  to view this content.

I think this will do what you want

Please Login or Register  to view this content.