match / manipulate arrays then paste back onto sheet

Hi all,

I am trying to consolidate unique data from 3 different excel files based on certain criteria (units bought > 0).

To illustrate things better, I have mocked up a sample file with 3 Buy sheets that represent the 3 excel files. All of them have the same number of columns/ column names / range names etc., so there's 100% consistency. Now there's 3 people maintaining these three files and putting in the Materials they want to buy and the number of units per region as well as an "x" in the cluster section to indicate where the item should be send to.

Now, Buyer 1 might buy Material XYZ but only for Japan and Buyer 2 also buys the exact same Material for Korea, hence the sheet "Total" should only paste the Material once and put the correct "x"s and units in each of the regions as found in these 3 files.

Also, only columns in my range "PasteArea" should be filled with the data from the other files, every other column contains a formula and should be calculated automatically...

Below code gives me exactly the output I need, but it is running incredibly slow as it does it cell by cell. I need someone's help to use jagged arrays or scripting dictionaries instead to manipulate the data first before pasting it back onto the sheet

Please Login or Register  to view this content.