+ Reply to Thread
Results 1 to 3 of 3

Way to save a logo in a cell in order to reference it from other sheets

  1. #1
    Registered User
    Join Date
    05-02-2005
    Posts
    67

    Way to save a logo in a cell in order to reference it from other sheets

    I have a multi-sheet workbook with a some raw data that I import into Excel from another system. I then perform calculations & summaries in one of 10 other sheets. In order to make it more readable, I world like put the company logo on the top of each sheet.

    Is there a way to create a Input type of sheet that I put the logo in and then on each of reporting sheets do an ='Input'!location_of_logo_cell type of formula, in a similar way that I would pull data from that same sheet, like ='input'A1?

    It becomes very labor intensive if I want to make changes to the logo and then copy it to every sheet.

    Thanks in advance for your thought on this!
    Jim
    Last edited by jshrader; 11-25-2009 at 02:52 AM. Reason: Solved

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Way to save a logo in a cell in order to reference it from other sheets

    Hi,

    you could set up your logo on the first sheet and then use the camera tool to copy and paste it onto other sheets. It's like a linked snapshot. In excel 2003 the camera tool is well hidden, and you'll have to go through the tool bars - Customise ... and add its icon to a toolbar to use it.

    hth
    Last edited by teylyn; 11-25-2009 at 01:23 AM.

  3. #3
    Registered User
    Join Date
    05-02-2005
    Posts
    67

    Re: Way to save a logo in a cell in order to reference it from other sheets

    Thanks for the quick turnaround!!! You were right, it was a little hard to find. I think the camera tool will work for me!
    Last edited by jshrader; 11-25-2009 at 02:49 AM. Reason: Solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1