VLOOKUPS

I have data in the following format:

Name Date Amount
Johnson 6/1/06 $100
Johnson 6/6/06 $300
Johnson 6/13/06 $350
Smith 6/2/06 $450
Smith 6/5/06 $100
Jones 6/16/06 $225

Every month the amount of times the name shows up will be different as well
as the dates they used the money.

I have different sheets for each name but i need to pull the dates and
amounts into seperate columns being:

Date Amount

Any help is greatly appreciated!

Hi Brett,

could you give an example of how you want the data to look?
--
Cillian


"Brett" wrote:

> I have data in the following format:
>
> Name Date Amount
> Johnson 6/1/06 $100
> Johnson 6/6/06 $300
> Johnson 6/13/06 $350
> Smith 6/2/06 $450
> Smith 6/5/06 $100
> Jones 6/16/06 $225
>
> Every month the amount of times the name shows up will be different as well
> as the dates they used the money.
>
> I have different sheets for each name but i need to pull the dates and
> amounts into seperate columns being:
>
> Date Amount
>
> Any help is greatly appreciated!
>
>

JOHNSON
Date Amount
6/1/06 $100
6/6/06 $300
6/13/06 $350

"Cillian" wrote:

> Hi Brett,
>
> could you give an example of how you want the data to look?
> --
> Cillian
>
>
> "Brett" wrote:
>
> > I have data in the following format:
> >
> > Name Date Amount
> > Johnson 6/1/06 $100
> > Johnson 6/6/06 $300
> > Johnson 6/13/06 $350
> > Smith 6/2/06 $450
> > Smith 6/5/06 $100
> > Jones 6/16/06 $225
> >
> > Every month the amount of times the name shows up will be different as well
> > as the dates they used the money.
> >
> > I have different sheets for each name but i need to pull the dates and
> > amounts into seperate columns being:
> >
> > Date Amount
> >
> > Any help is greatly appreciated!
> >
> >

Hi Brett, did you try a Pivot Table?

HTH
Regards from Brazil
Marcelo

"Brett" escreveu:

>
> JOHNSON
> Date Amount
> 6/1/06 $100
> 6/6/06 $300
> 6/13/06 $350
>
> "Cillian" wrote:
>
> > Hi Brett,
> >
> > could you give an example of how you want the data to look?
> > --
> > Cillian
> >
> >
> > "Brett" wrote:
> >
> > > I have data in the following format:
> > >
> > > Name Date Amount
> > > Johnson 6/1/06 $100
> > > Johnson 6/6/06 $300
> > > Johnson 6/13/06 $350
> > > Smith 6/2/06 $450
> > > Smith 6/5/06 $100
> > > Jones 6/16/06 $225
> > >
> > > Every month the amount of times the name shows up will be different as well
> > > as the dates they used the money.
> > >
> > > I have different sheets for each name but i need to pull the dates and
> > > amounts into seperate columns being:
> > >
> > > Date Amount
> > >
> > > Any help is greatly appreciated!
> > >
> > >

I thought about the same thing but my boss wants it to be in the format i
have listed. Thanks anyways

"Marcelo" wrote:

> Hi Brett, did you try a Pivot Table?
>
> HTH
> Regards from Brazil
> Marcelo
>
> "Brett" escreveu:
>
> >
> > JOHNSON
> > Date Amount
> > 6/1/06 $100
> > 6/6/06 $300
> > 6/13/06 $350
> >
> > "Cillian" wrote:
> >
> > > Hi Brett,
> > >
> > > could you give an example of how you want the data to look?
> > > --
> > > Cillian
> > >
> > >
> > > "Brett" wrote:
> > >
> > > > I have data in the following format:
> > > >
> > > > Name Date Amount
> > > > Johnson 6/1/06 $100
> > > > Johnson 6/6/06 $300
> > > > Johnson 6/13/06 $350
> > > > Smith 6/2/06 $450
> > > > Smith 6/5/06 $100
> > > > Jones 6/16/06 $225
> > > >
> > > > Every month the amount of times the name shows up will be different as well
> > > > as the dates they used the money.
> > > >
> > > > I have different sheets for each name but i need to pull the dates and
> > > > amounts into seperate columns being:
> > > >
> > > > Date Amount
> > > >
> > > > Any help is greatly appreciated!
> > > >
> > > >

Would a pivot table be the only way to do this?

"Brett" wrote:

> I have data in the following format:
>
> Name Date Amount
> Johnson 6/1/06 $100
> Johnson 6/6/06 $300
> Johnson 6/13/06 $350
> Smith 6/2/06 $450
> Smith 6/5/06 $100
> Jones 6/16/06 $225
>
> Every month the amount of times the name shows up will be different as well
> as the dates they used the money.
>
> I have different sheets for each name but i need to pull the dates and
> amounts into seperate columns being:
>
> Date Amount
>
> Any help is greatly appreciated!
>
>