Hi, i have a sheet with tree coluns, onde for "Date", other for
"Product" and the last for "Value".
For example:

Date Product Value
01/01/09 A 100
01/02/09 B 150
01/03/09 A 120
01/04/09 B 110
01/05/09 A
10

I want to make a macro that give me the values of all produts for the
last date.

Can you help me?

Thanks

Bruno,

What result would you expect from your sample data and why?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Bruno" wrote:

Hi, i have a sheet with tree coluns, onde for "Date", other for
"Product" and the last for "Value".
For example:

Date Product Value
01/01/09 A 100
01/02/09 B 150
01/03/09 A 120
01/04/09 B 110
01/05/09 A
10

I want to make a macro that give me the values of all produts for the
last date.

Can you help me?

Thanks
.

On Apr 8, 9:58*am, Mike H wrote:
Bruno,

What result would you expect from your sample data and why?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"Bruno" wrote:
Hi, i have a sheet with tree coluns, onde for "Date", other for
"Product" and the last for "Value".
For example:

Date * * * * * * * * * Product * * * * * * * * * * * * * * * * Value
01/01/09 * * * * * * A * * * * * * * * * * * * * * * * * * * * * * 100
01/02/09 * * * * * * B * * * * * * * * * * * * * * * * * * * * * * 150
01/03/09 * * * * * * A * * * * * * * * * * * * * * * * * * * * * * 120
01/04/09 * * * * * * B * * * * * * * * * * * * * * * * * * * * * * 110
01/05/09 * * * * * * A
10

I want to make a macro that give me the values of all produts for the
last date.

Can you help me?

Thanks
.

On Apr 8, 9:58 am, Mike H wrote:
Bruno,

What result would you expect from your sample data and why?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"Bruno" wrote:
Hi, i have a sheet with tree coluns, onde for "Date", other for
"Product" and the last for "Value".
For example:

Date Product Value
01/01/09 A 100
01/02/09 B 150
01/03/09 A 120
01/04/09 B 110
01/05/09 A
10

I want to make a macro that give me the values of all produts for the
last date.

Can you help me?

Thanks
.

well Mike, i expect that the macro give me, in a new worksheet, all
products in data (A and B) and the last price with correspondent date

Result:
Date Product Value
01/05/09 A
10
01/04/09 B 110

Bruno