ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linking Objects (https://www.excelbanter.com/excel-worksheet-functions/234035-linking-objects.html)

Humble09

Linking Objects
 
Hi,
I would like to know is it possible to link a cells to one column. I have a
person who has mutliple keys and I would like to list all those keys in one
row rather than make a new row for each key. Is it possible to have all those
keys listed and group them to that one person listed in the column? I would
need to add a lot of people to the worksheet.


LAST NAME FIRST NAME KEYS KEYS
Sample Mrs. C0xxE-4
C0x8x-15

Smith John OxG-56
G-x-8
CO6-A
G1x-1x
G1xA-X
Can I group this information so that those listed for Mrs.Sample are only
reference to her as for Mr. Smith?
--
Thank you


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com