Need Help with Formula R1C1 Loop

[Syed Subhahan]

Hello,

I'm new to this forum and also to VBA. I have a data series in a sheet.
For example, Column A has rows A1:A5, I want to concatenate the fields in such a way that the result should be as below.

A1/A2
A1/A3
A1/A4
A1/A5
A2/A3
A2/A4
A2/A5
A3/A4
A3/A5
A4/A5

then move to the next column in the same sheet.

Any help would be greatly appreciated.

Thank you.

[JBeaucaire]

This little macro will do what you want with column A, however many values you have entered in column A, creating your list of combinations in column M:

Please Login or Register  to view this content.

[Syed Subhahan]

Thank you very much for the code. Just to modify the query, maximum rows in each column skipping the first row is 20. So, I'm looking for the result of column A starting from A20 however the code should execute from A2, as A1 has a unique identifier for this series to identify. Also it should move to Column B once the process in Column A is executed.

Please suggest.

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a workbook with clear sample data and sample results. Show us the whole thing.

[Syed Subhahan]

Added as requested.

[JBeaucaire]

Click GO ADVANCED and use the paperclip icon to post up a workbook with clear sample data and sample results. Show us the whole thing.

Almost got it all... no sample results.