PC Review


Reply
Thread Tools Rate Thread

Compare and report differences.

 
 
=?Utf-8?B?UGV0ZQ==?=
Guest
Posts: n/a
 
      9th Nov 2005
I have a spreadsheet that has a list of customers order for Last weeks in one
tab and this weeks order in a second tab. Both tabs are very similar to what
is listed below.

What I want to do is compare the tabs and report the differences that occur
on a separate tab for further processing. I.E if ABC co ships order # 4066 I
want it to list the customer name and order # that is not present in Column A
and B of the 3rd tab (Shipments). And like wise if ABC co enters a new order
I want the customer name and new order number listed in column A and B of the
4th tab (New Orders).

Column A lists all the customer with spaces separating one from the other.
Column B Has the specific job #'s associated with the customer listed in
column A. (Starting at 2 Cells down and 1 cell to the left of the customer
name with additional orders (as many as 30) listed under the first in B)
Column C-V has various other info

A B C-V
1
2
3
4 ABC Comp
5
6 4066
7 4850
8
9 LMN Comp
10
11 4857
12 3989
13
14 XYZ Comp
15
16 14957
17
18 123 Comp
19
20 5799

I have tried Range name, lookup formulas and various other codes that I have
used in the past for similar stuff, but I can't seam to make this work. I
know someone out here has a fast and easy way of doing this.
--
Pete

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare and highlight differences in 2 worksheets in same workbookand list differences in 3rd worksheet Joshua Houck Microsoft Excel Programming 21 19th Aug 2011 12:21 PM
Compare 2 pivot tables and report differences E Microsoft Excel Worksheet Functions 2 1st Jan 2007 07:51 PM
How to compare two tables and report only the differences =?Utf-8?B?U3dlZXRldGM=?= Microsoft Access 4 16th Nov 2006 05:53 PM
Compare differences between PPT documents SV Microsoft Powerpoint 0 25th Oct 2005 12:31 PM
How to show only differences after compare Al Microsoft Word Document Management 2 4th May 2005 03:28 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:03 AM.