Hi,
I have a VERY long spreadsheet that I need to export into Word splitting the data into multiple segments in the process and saving each segment as a separate Word file. Is is doable?
[column1] [column 2] ....
code001 entry1
code001 entry2
....
code099 entry1, etc.
What I really need here is to have Excel create a file "Code001.docx" containing all entries for [columns 1-5] where [column 1] = "code001", then create a file "Code002.docx" containing all entries for [columns 1-5] where [column 1] = "code002" and so on. It would be absolutely terrific if there was a way to make Excel automatically put "Code001", "Code002", etc as a header into every file (and make the header itself 0.7'' in height), and format the data into 2 columns with a line between and a 1'' gap between the columns.
If this is not an outlandishly tall order, any help would be much appreciated.
I have a VERY long spreadsheet that I need to export into Word splitting the data into multiple segments in the process and saving each segment as a separate Word file. Is is doable?
[column1] [column 2] ....
code001 entry1
code001 entry2
....
code099 entry1, etc.
What I really need here is to have Excel create a file "Code001.docx" containing all entries for [columns 1-5] where [column 1] = "code001", then create a file "Code002.docx" containing all entries for [columns 1-5] where [column 1] = "code002" and so on. It would be absolutely terrific if there was a way to make Excel automatically put "Code001", "Code002", etc as a header into every file (and make the header itself 0.7'' in height), and format the data into 2 columns with a line between and a 1'' gap between the columns.
If this is not an outlandishly tall order, any help would be much appreciated.