Demo Table

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

Thread: Demo Table

  1. #1
    New Member
    Join Date
    Feb 2003
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Demo Table

     
    I have a "print out" that goes to clients and I need to insclude a demographic table (which is already located on another worksheet in the file). However, I want it to be small. How can this be done without having to link cells. Can it be treated as a picture or something?

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,498
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Demo Table

    Welcome to the Board!

    Why not do a SaveAs, then Copy-->Edit-->Paste Special-->Values. This will eliminate links to other sheets/workbooks. If that's not an option, try posting some of your sheet using Colo's HTML Maker, which can be found at the bottom of the page.

    Hope that helps,

    Smitty

  3. #3
    Board Regular Iridium's Avatar
    Join Date
    Jul 2002
    Location
    Walsall, England
    Posts
    2,831
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Demo Table

    You can make a picture out of a range of cells by copying them then whilst holding Shift go to Edit>Paste Picture. Resize as required etc

    HTH
    Iridium


  4. #4
    New Member
    Join Date
    Feb 2003
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Demo Table

    What if I have the option of 4 different demo tables depending on the type selected? And I only want the table selected to be automatically put on the output?

  5. #5
    Board Regular Iridium's Avatar
    Join Date
    Jul 2002
    Location
    Walsall, England
    Posts
    2,831
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Demo Table

    You never mentioned 4 different demo tables in your original question and what do you mean by 'depending on the type selected'. How is your s/s set-up?
    Iridium


  6. #6
    New Member
    Join Date
    Feb 2003
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Demo Table

    Each demo table is located on a seperate worksheet. The user enters the type; 4,3,2, R and a macro takes them to the appropriate sheet.

  7. #7
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,498
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Demo Table

      
    You can incorporate either of our suggestions in your Goto code by selecting each demographic table's range..

    Smitty

User Tag List

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
  •  

 

 
DMCA.com