stefanaalten
Board Regular
- Joined
- Feb 1, 2011
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
I have two worksheets:
- a "Titles" worksheet with 1500 films (title, director, year, etc.), one per row.
- a "Directory" worksheet which shows the same information but in a different layout, each film on a "index card layout", more suitable for printing. The card layout has space for a small image (to display a thumbnail of the movie poster or something).
The Directory worksheet updates automatically when films are updated/inserted/deleted from the Titles worksheet, in other words the Directory worksheet only contains cell references to the Titles worksheet, no actual data of its own.
I want to keep the "Titles" worksheet as the information master.
How can I include an image for a film i.e. a row in the Titles worksheet and then reference (i.e. display) that image in the corresponding entry in the Directory worksheet?
If I "insert picture" in a given cell on the Titles worksheet it is positioned correctly on the row, but the cell itself appears to be "empty" (apart from the image "floating above it"), and I don't know how on the Directory worksheet I would insert a function that says "display the same image here as in cell X on the Titles worksheet".
I'm conscious that inserting many small images will increase the file size, but am keen to keep the file "self-contained".
Many thanks for any help!
- a "Titles" worksheet with 1500 films (title, director, year, etc.), one per row.
- a "Directory" worksheet which shows the same information but in a different layout, each film on a "index card layout", more suitable for printing. The card layout has space for a small image (to display a thumbnail of the movie poster or something).
The Directory worksheet updates automatically when films are updated/inserted/deleted from the Titles worksheet, in other words the Directory worksheet only contains cell references to the Titles worksheet, no actual data of its own.
I want to keep the "Titles" worksheet as the information master.
How can I include an image for a film i.e. a row in the Titles worksheet and then reference (i.e. display) that image in the corresponding entry in the Directory worksheet?
If I "insert picture" in a given cell on the Titles worksheet it is positioned correctly on the row, but the cell itself appears to be "empty" (apart from the image "floating above it"), and I don't know how on the Directory worksheet I would insert a function that says "display the same image here as in cell X on the Titles worksheet".
I'm conscious that inserting many small images will increase the file size, but am keen to keep the file "self-contained".
Many thanks for any help!
