Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Advice: Screenshots and

  1. #1
    New Member
    Join Date
    Jun 2017
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Advice: Screenshots and

    Hi all,

    I have a report compiled by the WHO (World Health Organisation) and I want to use one table for a document (a data report) that I am compiling for healthcare in a number of counties.

    Currently, I am cutting screenshots of the table and pasting them into my report. It perfectly suits my needs - I don't need the raw data, I don't need to compile a table, and the same table works for all of the reports that I am preparing for each county.

    What I want to know is - can I put the screenshot into a cell in excel, and then pull that cell into a word document (i.e. insert object).

    The reason why I ask this is that I want to increase the number of screenshots that I am taking to populate my county reports. And I would like to change the screenshots from last month's data to this month's data.

    I hope this makes sense.

    Any advice on a better way would also be gratefully accepted.

  2. #2
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    3,218
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Advice: Screenshots and

    You could copy the Excel range spanned by the screenshot and paste that into Word using Paste Special with the 'paste link' option. That will link the document to the corresponding Excel range and keep them synchronized.
    Cheers
    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Member
    Join Date
    Jun 2017
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Advice: Screenshots and

    Genius!! Works a treat - thank you. Thank you.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •