Hello,
I would love some help and advice from qualified Excel users out there (which I am not). I
I would like to create a table subset to a source table. I have tried to use a pivot table but it does not allow me to use my final table for the outcome I want (or I least I don't how to make it work).
In table 1 I have a set of data corresponding to a specific client. This table is long as I am dealing with dozens of clients.
I would like table 2 to show this corresponding data per client. This table only contains the information related to a specific client. Table 2 has to be automatically populated according to the client4s name.
A screenshot of what I am trying to achieve for better understanding:
In advance, thank you !
Manon
I would love some help and advice from qualified Excel users out there (which I am not). I
I would like to create a table subset to a source table. I have tried to use a pivot table but it does not allow me to use my final table for the outcome I want (or I least I don't how to make it work).
In table 1 I have a set of data corresponding to a specific client. This table is long as I am dealing with dozens of clients.
I would like table 2 to show this corresponding data per client. This table only contains the information related to a specific client. Table 2 has to be automatically populated according to the client4s name.
A screenshot of what I am trying to achieve for better understanding:
In advance, thank you !
Manon