Alexon2008
01-28-2013, 02:55 PM
Hello!
I have a spreadsheet with flg style:
Column A --- Sales Locations 1,2,3,4,5 etc.
Column B ---- Item number (6 digits)
Column C ---- Prices
I want to macro to find identical item number at different sales locations and then substract prices from our targets prices which are prices at sales location 3 or 5.
As prices for sale locations 3 and 5 are our target prices I want to compare all other sales locations prices to those.
For instance, I would like that macro find item no 450560 at the factory 11 andthen identical item no. at factory 3 or 5 and then substract prices fra sales location 11 from sales location 3 or 5. Prices wil be eather on places 3 or places 5.
I have a spreadsheet with flg style:
Column A --- Sales Locations 1,2,3,4,5 etc.
Column B ---- Item number (6 digits)
Column C ---- Prices
I want to macro to find identical item number at different sales locations and then substract prices from our targets prices which are prices at sales location 3 or 5.
As prices for sale locations 3 and 5 are our target prices I want to compare all other sales locations prices to those.
For instance, I would like that macro find item no 450560 at the factory 11 andthen identical item no. at factory 3 or 5 and then substract prices fra sales location 11 from sales location 3 or 5. Prices wil be eather on places 3 or places 5.