Hi,
I'm trying to figure out how to link the contents of a text box to another cell on a worksheet within the same workbook. I may be going about this the wrong way, so let me just summarize what it is I'm trying to do:
I have worksheets all formatted off the same "memo" template, and they include a text box, because that's the only way I can format the text exactly how I want the memo to print out. I also have a summary page at the beginning of the workbook that is linked to various cells within each of these worksheets. This is so I can get a quick snapshot of important information contained in each memo. I'd like the information in the text box to also show up on the summary page, but I don't know how to link the contents. I know how to link a cell to a text box so that the contents of the cell show up in the text box, but what I am trying to do is the reverse.
Do I need a macro for this? Can anyone help?? Thanks!
Bookmarks