joeyc
06-25-2008, 10:15 PM
Hi,
This is a general question. I never did something like this before and I don't think my current approach is right so I am asking for some strategy assistance on this one.
On Sheet1 of a workbook, I have questions and answers. The answers to these questions come in the form of text data that is rather long. On average, each answer is 2,000 characters. Now, these 2,000 character answers are linked to multiple sheets in this workbook. Currently, I have the cells wrapped and a user can only read these answers on linked sheets by copying the cell into say Microsoft Word and viewing them. Currently, I have all of this done in Microsoft Word, but it annoying because I have to scroll so much to get to where I want and with Excel you have sheets and I can put this info on separate sheets and not have to scroll.
Is their any better way to do this that immediately jumps out at you? Ideally, I would like one to be able to view the linked data on another sheet [NOT to have to paste it into a word processor] and for this innovation to take up AS LITTLE SPACE AS POSSIBLE. I have lots of questions being linked and space is important so it doesn't look clunky.
Any suggestions?
This is a general question. I never did something like this before and I don't think my current approach is right so I am asking for some strategy assistance on this one.
On Sheet1 of a workbook, I have questions and answers. The answers to these questions come in the form of text data that is rather long. On average, each answer is 2,000 characters. Now, these 2,000 character answers are linked to multiple sheets in this workbook. Currently, I have the cells wrapped and a user can only read these answers on linked sheets by copying the cell into say Microsoft Word and viewing them. Currently, I have all of this done in Microsoft Word, but it annoying because I have to scroll so much to get to where I want and with Excel you have sheets and I can put this info on separate sheets and not have to scroll.
Is their any better way to do this that immediately jumps out at you? Ideally, I would like one to be able to view the linked data on another sheet [NOT to have to paste it into a word processor] and for this innovation to take up AS LITTLE SPACE AS POSSIBLE. I have lots of questions being linked and space is important so it doesn't look clunky.
Any suggestions?