Add coma to a list, paste it to a cell and copy it

[axtryo]

Hi,

Attached is a sample book containing a table. I need code to find the word "SKU" (or have a message box asking for the range to look at. In this sample, the word "SKU" is located at B1, but could be located anywhere else). Then, find the next empty cell at the row where the word SKU is located (in this case, F1), add commas in between each record from the column, and lastly, copy that content to the clipboard.

Each table will be different, containing a variable number of rows and columns (but there will always be at least an empty column in between them if more than one are present), and each sheet will come with a different name from my colleagues.

Any help with this will be highly appreciated.

Thanks!

[jindon]

F1
=VConC(B2:B10,",")

Please Login or Register  to view this content.