Linking data in reverse

[dangim1]

Hi all,

I have created a workbook which consisted of one worksheet in total. You could say it was similar to a summary page, but without really summarizing anything as all of the information was collected in that one sheet.

I now wish to change the formatting of the document as I need to input further information, however some cells contain multiple alphabetical values.
This is proving to be difficult, as I am unable to link the data from the summary page into the new pages, without deleted those multiple values.

The workbook is quite simple, it is a database including column headings such as; Name, Number, Email, Association, Committee, Working group, Task force, Exec position.
(I have placed Association in bold as this is the column that which persons could be a part of multiple associations, and therefore currently in my spreadsheet there are multiple values in the one cell).

This is an example of what is currently looks like in basic form:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Name[/TD]
[TD]number[/TD]
[TD]email[/TD]
[TD]assoc.[/TD]
[TD]WG[/TD]
[TD]TF[/TD]
[TD]Comm.[/TD]
[TD]EP[/TD]
[/TR]
[TR]
[TD]bob[/TD]
[TD][/TD]
[TD][/TD]
[TD]1,3[/TD]
[TD]1) blah blah
3)blah blah[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]jane[/TD]
[TD][/TD]
[TD][/TD]
[TD]1,3[/TD]
[TD]1) blah blah
3)blah blah[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD][/TD]
[TD][/TD]
[TD]2,4[/TD]
[TD]4)blah[/TD]
[TD][/TD]
[TD]2)blah[/TD]
[TD]2)blah[/TD]
[/TR]
[TR]
[TD]janet[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]2)blah[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]lora[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2)blah[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bill[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]2)blah[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]














I have thought about a few possibilities but I'm still not 100%... Would It work to simply keep the one summary page if I formatted the data in a different way, eg:

To have Association in column A, but use in with the function of rows ie.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Assoc[/TD]
[TD]Name[/TD]
[TD]Email[/TD]
[TD]Number[/TD]
[TD]Comm.[/TD]
[TD]TF[/TD]
[TD]WG[/TD]
[TD]EP[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]bob[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]jane[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Bill[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mark[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Lora[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]bob[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]jane[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mark[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Janet[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

















Alternatively, I was thinking I should create a new sheet for each Assoc.
If I do this, I don't want to manually input everything again, also I want that when people update the info from each individual Assoc. worksheet, that it amends the summary page (& vice versa).

How can I format the worksheet to be less complicated and only have 1 value per cell in the summary page, whilst keeping the same relative size;
and link that data potentially into new individual assoc. spreadsheets?




I appreciate you having taken the time to read this post, and look forward to your response.


Kindest Regards,

Daniel