Linking comments between worksheets

Question

I know how to link the data in cells from 'Sheet1' to 'Sheet2', but its there a way to also link the comments?

For example, I have a data in cell A1(Sheet1) and a comment with two different dollar amounts and I've linked that to B2(Sheet2). The data shows up, but I also need the comment from A1 to show up. Any ideas? Thank you!

Answer 1

Could be your idea of a "comment" means simply a typed explanation of terms rather than an actual cell Comment which requires manual input or programming to alter?

Is this what you mean by comment?

If a Comment as shown, you will require programming to insert a note or value when you choose a plumber by whichever means have not yet been revealed.

The only fact revealed so far is a price in A1

Do you have a sample workbook you could upload to OneDrive or other file-sharing site?

Copy the URL then post it.

Gord

Answer 2

This is for a pricing spreadsheet we use to give quotes to customers. Let's say cell A1 in Sheet1 is the price for the plumbing labor. The comments for that cell would change based on which plumber we want to use for the project. I use Sheet1 to put in the labor and material costs and my project managers use Sheet2 to collect that info and give it to the subcontractors. Does this make sense?

Answer 3

I believe the only way to do this is to use VBA and would most likely involve a cell to store the textvalue to link to the Comment in Sheet2B2

What type of data is in Sheet1A1?

When, why and how is the Comment in Sheet1A1 changed?

Gord

Answer 4

Thanks Gord, but I also need the comment from Sheet2B2 to change when the comment from Sheet1A1 changes.

Answer 5

Select Sheet1A1 then Edit>Copy

Select Sheet2B2 and Edit>Paste Special>Paste Link

With B2 still selected, Edit>Paste Special>Comment>Esc

Gord