View Single Post
 
Old 07-13-2010, 06:06 AM
swedy13 swedy13 is offline Windows XP Office 2007
Novice
 
Join Date: Jul 2010
Posts: 1
swedy13 is on a distinguished road
Default Using Spreadsheet to integrate Google forms and MS Word

Hi, I run a web content company and am having trouble scaling due to my poor technical knowledge.

Currently, my writers complete an assignment by adding text to predefined text boxes in a Google form. This form is then saved as an Excel sheet inside GDocs. When we find buyer, my management team simply extracts the content from each text box (spreadsheet field) and pastes it into the clients preferred text editor.

The problem is that whenever I need to send a document back to my writers for editing or revisions, I have to extract all of the Excel information, paste it into MS Word and adjust the formatting before adding editor notes and emailing them the copy. To make it worse, when they send the information back, it is stuck in a Word document and needs to be stored in a separate file.

Is there anyway to program Excel to download a single row of data into a pre-formatted Word document? Also, is it possible to reverse the process and paste content from Word into Excel and have it automatically format into the correct cells?

Sorry, I know this is probably confusing. I wish I knew of some simple way to operate this, but most of my writers are even more technically challenged than I am and have difficulty learning and using management software like Basecamp. Hopefully somebody understand what I'm asking for and knows of a solution. Thanks!
Reply With Quote