Please can some one help

I have two sheets- Sales and Report

On sheet “Sales” I have a column -B. This column lists the sales, which
are taken from sheet “report”
A B
Date Sales
01-Jul-04 -18,109.14

In the “report” sheet I have a jumble of information, though on column
I have a description with the last eight digits matching the date (in
every case)
G H I

-17,228.88 01.07.2004 Sales 01072004

What I want is a macro (formula) to look up “sales” column A2 for the
date. Convert it into the same format as in Sheet “Report” and search
for that value in column I (there will only ever be 2 transactions for
each date). Then I need the $ values (in column G) of each successful
find in column I to be added together and placed in Column B in Sales.


I have 7 months of hundreds of transactions to sort in this way and
haven’t been able to find a different way…. Help anyone??


---
Message posted from http://www.ExcelForum.com/

Fingers,

Forget formulas, and try a pivot table, based on the data on sheet Report.
Use H as your row key, and G as your data.

HTH,
Bernie
MS Excel MVP

"fingers26 >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Please can some one help
>
> I have two sheets- Sales and Report
>
> On sheet "Sales" I have a column -B. This column lists the sales, which
> are taken from sheet "report"
> A B
> Date Sales
> 01-Jul-04 -18,109.14
>
> In the "report" sheet I have a jumble of information, though on column
> I have a description with the last eight digits matching the date (in
> every case)
> G H I
>
> -17,228.88 01.07.2004 Sales 01072004
>
> What I want is a macro (formula) to look up "sales" column A2 for the
> date. Convert it into the same format as in Sheet "Report" and search
> for that value in column I (there will only ever be 2 transactions for
> each date). Then I need the $ values (in column G) of each successful
> find in column I to be added together and placed in Column B in Sales.
>
>
> I have 7 months of hundreds of transactions to sort in this way and
> haven't been able to find a different way.. Help anyone??
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

use vlookup function and reformat it.


On Wed, 15 Sep 2004 06:52:41 -0500, fingers26
<<(E-Mail Removed)>> wrote:

> Please can some one help
>
> I have two sheets- Sales and Report
>
> On sheet “Sales� I have a column -B. This column lists the sales, which
> are taken from sheet “report�
> A B
> Date Sales
> 01-Jul-04 -18,109.14
>
> In the “report� sheet I have a jumble of information, though on column
> I have a description with the last eight digits matching the date (in
> every case)
> G H I
>
> -17,228.88 01.07.2004 Sales 01072004
>
> What I want is a macro (formula) to look up “sales� column A2 for the
> date. Convert it into the same format as in Sheet “Report� and search
> for that value in column I (there will only ever be 2 transactions for
> each date). Then I need the $ values (in column G) of each successful
> find in column I to be added together and placed in Column B in Sales.
>
>
> I have 7 months of hundreds of transactions to sort in this way and
> haven’t been able to find a different way…. Help anyone??
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>



--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/