adding additional products to individual loc from a division source

I have a spreadsheet #1 as follows:

column A - Loc
column B - Division
Column C - item name
Column D - Sales units

I have another spreadsheet #2 as follows:

Column A - Division
Colum B - Item name
Column C - Sales units

I am trying to add any items not already listed on spreadsheet 1 from spreadsheet 2.

IF spreadsheet 1 column b = Spreadsheet 2 column A, if Spreadsheet 2 col b is not on Spreadsheet 1 column C, add to Spreadsheet 1 column C item name and Sales units(column d).

I can work with just adding the item names missing from spreadsheet 1 and vlookup sales.

Cant get to work?

I cannot attach an example but your macro only added one location missing division items, I need to add for 5,000 locations from 277 divisions.

Below is the spreadsheet I am trying to upload



loc div item sls
12 239 a 27.183123
12 239 b 64.640295
12 239 c 66.593562
12 239 d 66.245799
12 239 e 75.393198
12 239 f 37.667073
15 239 a 27.183123

I want formula to yeild:


loc div item sales
12 239 a 27.183123
12 239 b 64.640295
12 239 c 66.593562
12 239 d 66.245799
12 239 e 75.393198
12 239 f 66.593562
12 239 g 27.183123
12 239 h 66.245799
12 239 i 75.393198
15 239 a 27.183123
15 239 b 64.640295
15 239 c 66.593562
15 239 d 66.245799
15 239 e 75.393198
15 239 f 66.593562
15 239 g 27.183123
15 239 h 66.245799
15 239 i 75.393198


spreadsheet 2:

div Package sales
239 a 27.183123
239 b 64.640295
239 c 66.593562
239 d 66.245799
239 e 75.393198
239 f 66.593562
239 g 27.183123
239 h 66.245799
239 i 75.393198