Solved

Transferring select excel data to a Word Document

Posted on 2016-10-19
5
53 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
  • 3
  • 2
5 Comments
 
LVL 17

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 17

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 17

Expert Comment

by:Roy_Cox
ID: 41858936
Pleased to help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
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 …

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now