I am totaly new to VBA and guess I need to write a code for the problem.
I have two columns, say A and B. I need to copy value (text) from A only if B is active. The copy from all "active" cells in A shall be pasted in another cell on the same Sheet as a sequence, with ";" or "," between values.
So I was thinking something like this
Please Login or Register to view this content.
I hope some of you understand what you mean.