VBA to split table and retain formatting

[John42]

Hi Everyone,

I'm looking for a way to split a large table of data in to multiple workbooks, based on "Country Name", and need to retain the formatting (column width, row height, cell colour, font etc) of the original file. I assume VBA is the way to go for this and have found a code that can split the file, however it does not copy the formatting. I am very much a novice when it comes to VBA so I wonder would any of you have a VBA code that could achieve this, or at least point me in the right direction? Thank you!

John

 

[XLfriend777]

Hi John42. Welcome to the forum. Just a thought to hopefully get you started. You could copy the entire tab, which should retain the formatting, and then delete the part you don't need in the new tab. I hope that makes sense and at least gets this question some response.