Insert Comment based on cell value in a different worksheet.

[Clarkit]

Hello,

First off, I really appreciate it if you are able to help me out!

I have an excel document with 2 worksheets. One named "Estimate" and the other "AQ Data".

I want a macro to look at "AQ Data" P3:P1000 and IF there is a value in those cells, I want that value to be inserted as a comment into "Estimate" cell K#

So if P3 in "AQ Data" says "included in 3", I want a comment that says "included in 3" to be inserted to K10 in "Estimate".

Rows 10 and 3 in the two worksheets correspond to each other.

So basically whenever a value appears in P3:P1000 "AQ Data" I want that value to be inserted as a comment to the corresponding line in "Estimate"

Thanks, and Happy Holidays!

[fredlo2010]

Hi,

Perhaps this:

Please Login or Register  to view this content.

If you know whats the column with the most rows you can use this and adjust so the code will not have to go all the way down to 1000. I am sure you are using 1000 as a safe area?

Please Login or Register  to view this content.

Tanks

[Clarkit]

Thank you for your reply,

I tried out your suggestion and it worked very well. I appreciate it!

Rep'ed

[fredlo2010]

You are welcome. I am glad I was able to help