2 sheets- Need a macro take a value from one find it into another then copy a value

  • Thread starter Thread starter fingers26
  • Start date Start date
F

fingers26

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??
 
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
 
use vlookup function and reformat it.


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??
Click to expand...
 
Back
Top