Adding additional information without adding more cells

Hi Brad, welcome to the Forum.

I am having trouble understanding what you're describing. A comment is attached to a cell, and is visible in a box that can be hidden or shown. By default comments are hidden and become visible when you hover over the cell. Here's what is confusing me.

1. It makes no sense that your company doesn't want each contact to have its own row. That would be the textbook way to do this.
2. If you are putting this information in as comments, what other information is in the file? What cells are you putting the comments in?
3. What do you mean "it didn't show all of the contacts"? Do you have multiple contacts in the same comment box?

It is possible to resize comment boxes using macros but I feel that you need a more holistic solution that takes a different approach than doing this with comments. With the data in comments, you can't do anything with it unless you write macros to extract it.

How is your company using this data once it's in there?

Thanks for taking the time to help out.

1) Yeah, that was the first thing I suggested to them. For whatever reason, they'd prefer it be in the excel file, but "tucked away until requested". My guess is they have a main contact and probably don't need all the others, but want them just in case. If I can't find a solution here then I'm just going to have to tell them I'll need to do it that way or just not have the contacts.
2) Sorry, I forgot to say I just attached the comment to the F Name cell. Then inside the comment I follow this format:
Full Name Office-Telephone Cell-Telephone Email
Full Name Office-Telephone Cell-Telephone Email
etc
3) Yes, I have multiple contacts in one comment box. I have one comment box per company, and some companies have anywhere from 1-15 contacts inside the single comment box. This worked out fine until the comment box suddenly reverted back to its default size. When it did that, you could only see the information that fit inside it's default sized box. All the information was still there, but you had to edit the comment box to be able to actually see it.

My understanding is that my company intends to call the companies in this database and I guess try to generate some business. I was just hired on to do this so I'm not sure if they are planning to do more with it.

I can't think of a way to deal with this other than a macro. I have written a simple macro in the attached workbook (automatically size comment boxes to show all text.xlsm) that estimates the necessary size for the comment box to be a square and show all text. This may not be perfect for what you need but will give you a good idea of what is needed. Make sure that you are showing comments then press the button to run the macro. If you are not familiar with macros then this may need a lot more explanation.

Please Login or Register  to view this content.