I'm not very keen on lingo here so I'll try my best to explain what I'm attempting to do. I'm attempting to take a bunch of cells, written as text in excel and turn it into a Word or Publishing document. Multiple people will edit information into the excel and once all information is complete, it is to be transferred.
You can think of this as a Memo or Newsletter. I have tried to play with formatting in excel, including merging of cells but there are too many intricate spacing to think about prior to adding all the text/data for it to be functional just to convert.
Ideally what im looking for is a way to reference particular cells and place them in particular parts or format of the word/newletters. I'm starting from the assumption that there will be a template with predefined text boxes, spaces, etc in the document and upon macro command, these would get filled in and formatted according to their current settings.
Is this a possibility?
Are there any good online resources to get more information about this type of process? (Again not sure what im looking for as im not on the up and up with the language)
Is there a better program to complete this function in utilizing macros?
Thanks
Bookmarks