Solved

Transferring select excel data to a Word Document

Posted on 2016-10-19
5
92 Views
Last Modified: 2016-10-25
I have an excel spreadsheet, with multiple tabs, that I use to collect product on boarding documentation for a new application in  our company ( See New Service Onboarding v 1 6 template).   I need to take select information from that on boarding document, which will be filled out and saved as new onboarding document with the application name in it, and populate a word document template, see  product overview template, with that data from the excel document.

Here is the mapping of that data:
Excel                                           Word
General Information Tab (B5)                     Populate Product /Service: with data from General Information Tab (B5)
General Information Tab (B11)                   Populate Aliases/Key Words: with data from  General Information Tab (B11)
General Information Tab (B6)                     Populate Purpose:  with data from  General Information Tab(B6)
General Information Tab (B10)                   Populate Targeted users/LOB: from  General Information Tab(B10)
General Information Tab (B8)                     Populate Product Manager/Owner or contact: from General Information Tab(B8)
General Information Tab (B9)                     Populate Subject Matter Expert: from General Information Tab(B9)
ServiceNow Tab (B8)                                     Populate Configuration Item: from ServiceNow Tab (B8)
General Information Tab (B16)                   Populate System criticality:  from General Information Tab (B16)
Service Desk Information Tab (B5)             Populate Access Request Required?: from Service Desk Information Tab (B5)
Service Desk Information Tab (B6)             Populate Access Request Process: from Service Desk Information Tab (B6)
Service Desk Information Tab (B10)           Populate Product License Required?: from Service Desk Information Tab (B10)
Service Desk Information Tab (B11)           Populate Installation/license request process?: from  Service Desk Information Tab (B11)
Service Desk Information Tab (B14)           Populate  Workstation Installation/Web/Cloud?: from Service Desk Information Tab (B14)
Service Desk Information Tab (B16)           Populate Application URL: Service Desk Information Tab (B16)  

Hopefully that is clear and you can help me accomplish what I am looking to do.
New-Service-Onboarding-v-1-6.xlsx
Product-Overview-Template.docx
0
Comment
Question by:Rrave26
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 20

Accepted Solution

by:
Roy Cox earned 500 total points
ID: 41850614
Why not set the overview page in Excel?

You can transfer to Word but it would involve creating Bookmarks in Word with Matching  Names in Excel. Then VBA code to transfer the data. If you had the Overview in Excel you could populate using formula, something like the attached.
New-Service-Onboarding-v-1-6.xlsx
0
 

Author Comment

by:Rrave26
ID: 41851956
The reason that I didn't go down that path initially, was that we then have to import that page into ServiceNow as a Knowledge document.  Initially we don't have the ability, or I have not figured out how to yet, to import only one page, or tab, in this case.  I suppose I could use the set up you proposed, and then just copy and paste that page into a word document which could then be used as the import file into ServiceNow's KB module.  

Could we set up a script that would copy the overview page, open word, and paste that copied section?
0
 
LVL 20

Expert Comment

by:Roy Cox
ID: 41852430
Simply right click on the Tab, choose Move or Copy, then  in the next step click Create a copy and from the To Book dropdown choose New Workbook
0
 

Author Closing Comment

by:Rrave26
ID: 41858443
Thank you Roy, I have done that and amended my process a bit more.
0
 
LVL 20

Expert Comment

by:Roy Cox
ID: 41858936
Pleased to help
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question