Macro to Copy Formating from Previous Column and Paste into Last Column

Hi All,

My macro currently copies data and pastes into the next available column on a different sheet.
This will be run multiple times so a new column is constantly being added.

What I need is for the macro to copy the formatting from the previous column and paste it into the most recent column.

In the example file, on the Data tab, I would need the formatting from column E to be pasted into column F.
But this is dynamic. So next time the macro is run I would need the formatting from F to be pasted into G.

I can't figure out how to code the macro so it finds the second to last column with data in it, copy the formating, and paste that formatting into the very last column.
The End Result tab shows how it would look.

Thank you so much for your help!!

You can try something like this:

Please Login or Register  to view this content.

Perfect! It does exactly what I was looking for.

Thank you so much!