# dictionary question

#### Elainaz

##### New Member
Hi, is it possible two have two keys for each value?

Here's the problem I'm facing with. I have some balance sheets for different people with different dates in different worksheets and files. I want to extract certain data such as the numbers of equity or debt from balance sheet, and rearrange them into a time-series data in a new worksheet.

I googled some similar tasks and found the dictionary might help me with it. But I checked some dictionary sample code and found most of them are "a key for a value" patterns, which seems not applying to my problem. So I wander whether it's possible to have two keys for each value. Like, key1=date, key2=person name, and value=debt or equity.
So when I rearrange the data, I could list them like this:
 person A person B person C date1 equity1 equity2 equity3 date2 equity4 equity5 equity6 date3 equity7 equity8 equity9

<tbody>
</tbody>

If not, would you mind giving me a hint about how to deal with it? I'd really appreciate it. I just learnt vba for less than two months by myself. So sometimes I kinda fell that I'm lost and don't know where to go.

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### Norie

##### Well-known Member
Why not use a 'composite' key by combining the data and the name?

Last edited:

#### Elainaz

##### New Member
Do you mean combine the name and date with some punctuatuion between them, and use split to process the key when making a time series table?

#### Norie

##### Well-known Member
Yes, that's basically what I mean.

#### Kyle123

##### Well-known Member
Or nested dictionaries, a top level with unique dates and then one with names (or vice versa)

Replies
14
Views
511
Replies
0
Views
39
Replies
11
Views
297
Replies
19
Views
1K
Replies
1
Views
275