Adding comments to cells based in worksheet based on another worksheets contents

[Chalky1982]

Good Morning All, Please Help!!! Tuesday Challenge!

I have a worksheet 'live' that is populated by getpivotdata from a pivot table that is generated from a csv. see Attachment No1.
I also have a worksheet in the same spreadsheet (sheet3) that contains additional data by product and sequence number. See Attachment No2.
What i'm trying to do is........ If sheet 3 has data against a product and sequence number a comment is to be auto generated in the 'live' worksheet in the relevant cell showing the data contained in sheet 3.

Any ideas and support would be greatly appreciated. I'm all out of ideas!

I'm hoping i've explained my issue / objective well enough...

Thanks Andy

 

[Chalky1982]

Hi , Anyone have any ideas or even if my issue is possible to resolve? Thx Andy

 

[Chalky1982]

@kevin9999 I noticed a previous similar issue you resolved any ideas.
Any other members that can help - it is certainly greatly appreciated

 

[Chalky1982]

Any vba champions have any ideas?

 

[Chalky1982]

can anybody recommend someone who may be able to support. VBA Guru!