Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Transferring select excel data to a Word Document

Posted on 2016-10-19
5
Medium Priority
?
118 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 22

Accepted Solution

by:
Roy Cox earned 2000 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 22

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 22

Expert Comment

by:Roy Cox
ID: 41858936
Pleased to help
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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 describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

569 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