xxxr
10-16-2008, 08:02 AM
Hi all, i am a beginner in the vba environment who knows very little compared to most of you. Which is why i am seeking all your wisdom and experience in solving a few problems i'm facing right now.
Firstly, a little background of my problem (as attached):
In Sheet A, I have a table which shows the Names, Type of fruits and Date Purchased.
There are 4 names and 3 Types of fruits in total
Names: Alan, Tom, Alicia, John
Types of fruits: Apples, Pears, Oranges
In Sheet B, I would like to have a table which will sum up all of each type of fruits bought by each Name across all dates. As well as the earliest date that Name bought that type of fruit
For example: How many Apples did Alan buy across all dates
How many Apples did John buy across all dates
How many Oranges did Alicia buy across all dates
I'm hoping to automate the entire process with an assigned button in Sheet A. It is clearer if you look at the file I've attached. Hope my description is clear enough for all you guys to understand. Thanks in advance! :beerchug:
Firstly, a little background of my problem (as attached):
In Sheet A, I have a table which shows the Names, Type of fruits and Date Purchased.
There are 4 names and 3 Types of fruits in total
Names: Alan, Tom, Alicia, John
Types of fruits: Apples, Pears, Oranges
In Sheet B, I would like to have a table which will sum up all of each type of fruits bought by each Name across all dates. As well as the earliest date that Name bought that type of fruit
For example: How many Apples did Alan buy across all dates
How many Apples did John buy across all dates
How many Oranges did Alicia buy across all dates
I'm hoping to automate the entire process with an assigned button in Sheet A. It is clearer if you look at the file I've attached. Hope my description is clear enough for all you guys to understand. Thanks in advance! :beerchug: