Scrolling Text Box Within Worksheet From Another

[Nathan]

Hi!

I'm creating a spreadsheet which is designed to enter
updated comments against a customer account for the use by
sales people - basically a poor mans CRM system! What I'd
like to do is insert some sort of scrollable text screen
within a worksheet that links to a raw data worksheet in
the same spreadsheet. A little bit like this message box
that we type in while posting a message, but pulling back
information based on a specific condition like show me all
the comments on customer x that have been entered
previously. I'd GREATLY appreciate any advise!

 

[EarlK]

Nathan,

I'm not sure I have the gist of your question. It will probably require a
UserForm or text box control and some vba code to gather the information
(comments), display it, and tuck it away when done.

Another option is a nice wide column, with text wrap (Format - Cells -
Alignment), into which you add/edit comments. You can hide that column
(perhaps via a macro under control of a button) when you don't want it
taking up space. It may have to turn off the Wrap Text property too, when
hidden.

Not knowing how your data is organized, I don't know if I'm on Mars with
these ideas or not.