A macro which will search for multiple comments and put them all into one cell?

[Kitsan]

Probably the worst title in the history of this forum but i'm still recovering from a 10K race last night!

I'm trying without much luck to write a macro with VBA to search for multiple comments in the 'This Week Comments' column in the data tab and stick them all in the 'Comments' column of the 'Topsheet'.

The AR Assignment Number is the unique identifier for each document or order.

I can get Excel to put one comment in there, but not all of the different comments?

I hope someone can help as i'm really stuck.

[Winon]

Hello Kitsan,

Is the attachment function broken?

No, the Attachment feature works fine.

[Kitsan]

Ahh it's working now, must be the firewall at work.

If anyone could help it'd be great?

[Kitsan]

Have I worded the question badly?

My boss just sent me this if it makes any sense to you guys, i'm still very much a newbie to VBA:

I would just append them. Eg if you create a variable call MyComment then when you find the first comment you can say:

MyComment = MyComment & activecell.value

When you find the second comment it will be the same and so on.

[Kitsan]

BUMP

On advice from another forum i've shown how I want the Topsheet tab to represent the data that the macro retrieves:

search_macro.xlsx - 715 KB

Sorry, I had to host on there as my work laptop seems to block the attachment manager on this site