Comparing different worksheets

[jchichuv]

ok, this is the issue, i work normally with 3 or 4 different worksheets of inventory, one of the company that i work for, a shelter company, the one from customs and from the warehouse and i have to compare them, match them, know if they have different quantities or values and have all the information in a single worksheet.

for example lets call them worksheet 1,2, 3 and 4.

in worksheet 1 I have the same item twice in different rows and different quantities, in total lets say 3568.

In worksheet 2 i have that item only once and it says 3472.

in the 3rd i have the same item with 3568 but its on the first row.

and on the 4th i have it with 3500.

In my worksheet i have to know what inventory my company says that we have and the one that the shelter company said we have and show them the difference, if we need an adjustment.

can some one help me with this

 

[dourpil]

Hi,

Can you upload a sample of your file? It'll help helpers help you :]

 

[jchichuv]

#Material	Description	Unit Cost	WEC INVENTORY	QTY SCRAP WEC	PART MASTER INVENTORY SONI	ACTION	SONI SCRAP TO ADJUST	UofM
H09640000000000	CLIP,COPPER	0.012367	385,800.000000	-231.000000	2,429,383.00	FALSE	-2,043,583.00	Each
99-3227	PROTO INSULATOR	0.132212	31,080.000000	-460.000000	129,906.00	FALSE	-98,826.00	Each
003220003000000	CONTACT	0.085105	60,000.000000	#N/A	130,183.00	FALSE	-70,183.00	Each
VN321203	CABLE 3 COND 12AWG (56/28) 4MM H07RN-F	1.0552	61,202.000000	#N/A	118,191.27	FALSE	-56,989.27	Feet
99-1048GE15	BODY PLATED	0.190700	32,109.000000	-3,327.000000	85,484.00	FALSE	-53,375.00	Each
106511000095000	PIN CONTACT ASSEMBLY PLATED	0.240440	6,024.000000	#N/A	55,491.00	FALSE	-49,467.00	Each
BX1067	WHITE BAG 4" X 6"	0.020374	203,041.000000	#N/A	246,119.79	FALSE	-43,078.79	Each
99-0352	PROTO SPRING WASHER	0.018000	250,000.000000	#N/A	284,916.00	FALSE	-34,916.00	Each
A-59-102-1 M06	NUT, COUPLING	0.555120	17,836.000000	-13.000000	49,942.00	FALSE	-32,106.00	Each
306-B-1 M88	SOLDER PREFORM	0.007573	6,891.000000	-425.000000	36,010.00	FALSE	-29,119.00	Each
MA0048	LABEL THRML 3" X 1.5" BLA	0.003590	39,097.000000	#N/A	64,975.68	FALSE	-25,878.68	Each
1-7779-1 M05	CONTACT	0.095283	10,000.000000	#N/A	33,000.00	FALSE	-23,000.00	Each
CN104496	CONTACT	0.009376	75,000.000000	#N/A	95,881.51	FALSE	-20,881.51	Each
MA0135	LABEL WRAP AROUND 1 X 3.75	0.040515	5,854.000000	-1,804.000000	26,719.00	FALSE	-20,865.00	Each

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Slizer6893]

From what I understand you need a summary sheet of all unique items?

Sounds like the first worksheet would be a sumif on the item

The second, third, and fourth. If I understand correctly there will only be one instance of each item so a SUMIF or Index(match) or even a vlookup can be used.

I have no idea your cell references or how much data you are looking at but here is a shot in the dark

Summary Sheet

All items in Column A, Row 1 would include the worksheet data its coming from...warehouse...vendor,etc

For worksheet one it sounds like a simple sumif works

=sumif(Worksheet1'D:D,A2,A:A)

for the rest I would use a sumif still to be safe change the references?

Then create another set of 4 columns that compares differences to your inventory count?