Link multiple things into a single table

**danielshillcock** · 09-14-2011, 09:18 AM

Hi guys, I am new to programming in Excel

I am looking to take a matrices of data (see attachment) and display all corresponding data into a single cell

I,e, if there are multiple '1's in a populated table it would display all that they represent in another cell

I would like to do this for each column in the matrix. I don't think I've explained myself very clearly so if I need to give more details please just ask.

Attachments may give some help.

**danielshillcock** · 09-16-2011, 05:26 AM

Bumping for great justice!

**danielshillcock** · 09-20-2011, 08:10 AM

I have found a solution for anyone interested.

Find row in which row sits in main table, example below

F(ISERROR(MATCH($B$7,Capabilities!$B$6:$B$756,0)),0,MATCH(B7,Capabilities!$B$6:$B$756,0))

Populate main table using

Sub Macro1()
'
' Macro1 Macro
'

'
'row_start = 5 // not required?
'row_end = 376 'end row // not required?
'column_num = 4 'column number // not required?


For row_n = 4 To 376 ' Range from which data cells start
    real_row_n = Worksheets("WP Reqts").Cells(row_n, 4).Value 'Cell relates to cell row on capabilities spreadsheet
   rrr = 6 ' Starting column of capabilities matrix
    If real_row_n > 0 Then
      For col = 6 To 45 'Column range in which matrix sits (Not in capabilities spreadsheet)
          jjj = Worksheets("WP Reqts").Cells(row_n, col).Value
          Worksheets("Capabilities").Cells(real_row_n + 5, rrr).Value = jjj
          rrr = rrr + 1
      Next
    End If
 Next
End Sub

Not very well explained, but it's here should anyone need something similar.