P
Pete
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.
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.