Join Dennis Taylor for an in-depth discussion in this video Pasting picture links, part of Excel Tips Weekly.
- [Voiceover] In this workbook, there are four…separate sheets for each quarter.…First quarter, second quarter, and as I'm…clicking on these, you'll see immediately…they have exactly the same layout,…their formula's in place, they're the green cells…and the yellow cells at the bottom.…The other cells with white backgrounds…are simply values.…Now, what we'd like to be able to do…is to set up a summary sheet.…And I've done some of the work for this already.…Eventually what we will see or want to see…on each of these sheets here is an image…of the summary sheet.…Now, possibly this is projection data…well into the future, or maybe it's historical data.…
But no matter the situation, we should be able to…and we will be able to have, in effect,…on each of the quarter sheets, an image…of our summary sheet out here,…and it will be called a linked image,…and it will be, so to speak, live,…in other words, it will be truly reflective…of whatever changes occur on the summary sheet.…So unlike pasting a picture, this is going to be…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.