Update Main Record and Remove Duplicates

[CSC2100]

I have a spreadsheet with a list of items for a company inventory. For each item there is a row that has all the details related to the item. There is also a "sub-row" for each item that only has the item number and current costs and pricing for the item.

I have a 2-part task that I am having trouble with:

First: I have to essentially update the "main row" with the updated cost and pricing info from the "sub-row" wherever one would exist and...

Second: Delete the duplicate row for the item (the one with less info).

My production file has thousands of rows, but I have created a sample file if anyone can help me with getting my task accomplished. I am new to these forums, so I'm not sure how I could attach the sample file to this post, but if someone could tell me how to do that I will provide it. In the mean time I will just insert a screenshot.

 

[jindon]

Can you change dic to y

 

[CSC2100]

It looks like it still gets the Compile Error where it expects the "identifier or bracketed expression.

Right now it looks like this:

.item.(y).

The error occurs right at the first "(" after item.

 

[jindon]

myAreas(i).Item(y).Offset(,iii).Value = _

 

[CSC2100]

Thank you so much for your help on this task! It works perfectly for what I needed.

Thank you again!