Hi,
This may have been answered before.
I am looking to develop a excel system where I can enter the customers name and information on the first tab along with their sale item and then this information will feed through to a new tab based on the customers name.
If i had the below list
<colgroup><col><col><col span="2"><col span="2"></colgroup><tbody>
</tbody>
I would then want this information to feed to a separate tab for each person.
I can find the information using VLOOK up but then it will not show multiple items.
I would like the next tab to populate for Peter as per below
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
If I then had a new sale, I ad it to the main tab and it populates the other tabs for me.
Thanks in advance for your help.
Regards,
Peter
This may have been answered before.
I am looking to develop a excel system where I can enter the customers name and information on the first tab along with their sale item and then this information will feed through to a new tab based on the customers name.
If i had the below list
Account Name | Date | Product | Price | ||
1 | Peter | 01/01/2016 | Hat | 2.5 | |
2 | Paul | 06/01/2016 | Scarf | 3 | |
3 | David | 15/01/2016 | Hat | 2 | |
4 | Steven | 03/02/2016 | Gloves | 3.5 | |
5 | Peter | 06/02/2016 | Gloves | 3.5 | |
6 | David | 17/02/2016 | Scarf | 3 | |
7 | Peter | 20/02/2016 | Socks | 4 | |
8 | Steven | 25/02/2016 | Hat | 2.5 |
<colgroup><col><col><col span="2"><col span="2"></colgroup><tbody>
</tbody>
I would then want this information to feed to a separate tab for each person.
I can find the information using VLOOK up but then it will not show multiple items.
I would like the next tab to populate for Peter as per below
Account Name | Date | Product | Price | |
Peter | 01/01/2016 | Hat | 2.5 | |
Peter | 06/02/2016 | Gloves | 3.5 | |
Peter | 20/02/2016 | Socks | 4 |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
If I then had a new sale, I ad it to the main tab and it populates the other tabs for me.
Thanks in advance for your help.
Regards,
Peter