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!