I have a single column of cells and need to create a complete matrix. It is 100 cells to begin with which will be a huge matrix but here is a small sample of what I am trying to do.
Original File:
Column A Column B
1
2
3
Create:
Column A Column B
1 2
1 3
2 1
2 3
3 1
3 2
Please confirm whether VBA solution is Ok for you?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I am not familiar with VBA solution
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
Please Login or Register to view this content.
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Refer the attached file
see attached file
Last edited by samba_ravi; 12-05-2014 at 01:12 AM.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks