Linking data in reverse

dangim1

New Member
Joined
Jun 26, 2014
Messages
1
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:
Namenumberemailassoc.WGTFComm.EP
bob1,31) blah blah
3)blah blah
jane1,31) blah blah
3)blah blah
Mark2,44)blah2)blah2)blah
janet22)blah
lora22)blah
bill22)blah

<tbody>
</tbody>














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.

AssocNameEmailNumberComm.TFWGEP
1bob
jane
2Bill
Mark
Lora
3bob
jane
Mark
4Janet

<tbody>
</tbody>

















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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Watch MrExcel Video

Forum statistics

Threads
1,095,818
Messages
5,446,680
Members
405,413
Latest member
AlainCar

This Week's Hot Topics

Top