+ Reply to Thread
Results 1 to 5 of 5

Link Entire Column from one Sheet to the next

  1. #1
    Registered User
    Join Date
    04-27-2007
    MS-Off Ver
    2007
    Posts
    19

    Link Entire Column from one Sheet to the next

    I need to link an entire column from one sheet to another. How do I do this? Thank you!

  2. #2
    Forum Contributor
    Join Date
    08-10-2006
    Posts
    723
    hi,
    select the column you want to copy from then select edit > copy goto the next sheet and select the column you want the links to be in .
    select paste special then select paste link

    hope this helps

    steve

  3. #3
    Registered User
    Join Date
    04-27-2007
    MS-Off Ver
    2007
    Posts
    19
    Thank you!

    Now, when I paste link all the blank cells have a 0 in it. How do I get rid of the 0 and just leave a blank cell on the next sheet?

  4. #4
    Forum Contributor
    Join Date
    08-10-2006
    Posts
    723
    hi,

    goto tools >options> click on zero values

    steve

  5. #5
    Registered User
    Join Date
    04-27-2007
    MS-Off Ver
    2007
    Posts
    19
    One more question...then I'll stop bugging you (0;

    Since I am copying the whole column over there is a ton of blank space I don't need to print. I need to make this user friendly because people who don't usually use a computer will need to print this out. Thank you!

    Misty

+ 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