I’m looking for VBA macro code that can split a table into numerous worksheets by column value and keep formatting. 

Have an input to select which column needs to be split by data in that columnEach new worksheet should be named the name of the value from the original column that is being splitCopy formatting of table into new sheets (borders, column width, etc)The table does not always start in cell A1. For example, if table starts in C4 (would require some input, hopefully selecting the cell), copy the columns to the left, and rows above to paste on all new pages (information not including, but surrounding the table)

I posted an example of me doing the process manually below. Original is the original table with Result1 and Result2 being the worksheets created after the macro is run.

​I’m looking for VBA macro code that can split a table into numerous worksheets by column value and keep formatting. Have an input to select which column needs to be split by data in that columnEach new worksheet should be named the name of the value from the original column that is being splitCopy formatting of table into new sheets (borders, column width, etc)The table does not always start in cell A1. For example, if table starts in C4 (would require some input, hopefully selecting the cell), copy the columns to the left, and rows above to paste on all new pages (information not including, but surrounding the table)I posted an example of me doing the process manually below. Original is the original table with Result1 and Result2 being the worksheets created after the macro is run.   Read More

​