Macros

[beccy]

I currently have a macro that will break down a worksheet into new sheets based on the column number and the values in the column.

Is it possible to split the sheet down in the same way but instead of creating new tabs, creates new workbooks?

 

[sweater_vests_rock]

Try Workbooks.Add