LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Comparing worksheets & input data

Help please....I am trying to compare data in 2 sheets to get the difference
from month to month

#1 (previous month's forecast)
Customer Part number Dollars
ABD 1234 $500

#2 (current month's forecast)
Customer Part number Prev Month $ Dollars Difference
ABD 1234 ?? $600
$100

I am trying to find a formula that would compare the 2 worksheets : if
customer & part number match from #1 to #2 then input the dollars from that
customer on #1 to same customer on #2. One problem I run into is that there
could be a customer or part number addition or subtraction from one month to
another.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing data in multiple worksheets Chief1409 Excel Discussion (Misc queries) 3 February 13th 07 04:26 PM
Comparing Data from two 2 worksheets Roberto R Excel Discussion (Misc queries) 17 December 2nd 06 02:58 PM
Comparing Data from two 2 worksheets Roberto R Excel Worksheet Functions 1 November 18th 06 04:52 PM
Comparing Data Between Worksheets Bryan Excel Discussion (Misc queries) 2 July 19th 05 01:29 PM
need help comparing data in 2 separate worksheets \Wayne via OfficeKB.com\ Excel Worksheet Functions 0 July 6th 05 09:02 PM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"