Excel Macro to Create a Workbook for Each Col


I need help I know next to nothing about macros but I'm am working on a project that comes around every quarter and I know that there has to be an easier way. I need a macro that will create a new workbook for each value in row one and copy and paste the rest of the column with that value. I would also like for it always copy and paste all columns with nothing in row one. Can any one help me or point me in the right direction?