I need to link an entire column from one sheet to another. How do I do this? Thank you!
I need to link an entire column from one sheet to another. How do I do this? Thank you!
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
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?
hi,
goto tools >options> click on zero values
steve
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks