Macro to compare and move data from one worksheet to another

[dgezy]

I have 3 sheets, sheet1, sheet2, sheet3.
Sheet1 is the item file downloaded from my web site.
Sheet2 is the item file downloaded from supplier A
Sheet3 is the item file downloaded from supplier B
The only common identifier is the Manufacturer Code. Sheet1 it is in Column AF
Sheet2 it is in Column A Sheet3 it is in Column B
First and foremost I need to update inventory on a daily basis. Sheet1 has this in Column K, Sheet2 in Column U and sheet3 in Column R.

These are fairly large files and vary from day to day.
Sheet1 = 2400 + lines and through column AX
Sheet2 = 2300 + lines and through column W
Sheet3 = 14,000 + lines and through column U

Not all line items are included in all sheets, they are not in the same order and
many items are in one sheet and not another.
To further complicate things I am using excel 2011 for Mac. If necessary I can change to Excel for Windows but would prefer not.

I would like to be able to pick any column from sheets 2 and/or3 and be able to update it into sheet1 without affecting the remainer of items in sheet1 that are not the same as the other sheets.

I don’t understand macros at all but if possible would like to accomplish this with 2 or 3 clicks.

Any help and hand holding would be greatly appreciated

Thanks
Dave

 

[xladept]

Hi dgezy,

Check out the transfer module of MasterPeuList on my XLAdept.com website. In that module I had to load differently organized data and I used the User Defined Type "PEU" to do it. If you do you'll be able to consolidate the data by key and get anything you want with it!

 

[xladept]

Hi dgezy,

I suggest that you use an UDT for this task - you can see what I did by checking the Transfer module of MasterPeuList on my XLAdept.com website.

Sorry for the repetition - I didn't know that the first post took.

 

[dgezy]

Hi xladept,
Thanks for your attempt to help but what you are talking about and the files from your website are so far beyond me that I have no idea what it all means or what I was looking at.

Thanks again
Dave

 

[xladept]

Hi dgezy,

Maybe a little further down the road - have you begun to organize your code?

 

[dgezy]

xladept,

No I have not. This is so far beyond me that I don't know where or how to start. I was kind of hoping somebody would throe some code up there with how to use it and I would see if it sticks. Past that I did see that MRExcel apparently does custom coding. I will contact them if I don't accomplish anything in a few days.

Thanks again
Dave

 

[xladept]

Hi dgezy,

You've got to do some schlepping. Start by listing the unique fields, the way they're named by each sheet then make a master sheet with the field names as headings.

Do some doodling after that and some line of attack will probably occur to you, often the solution is in the doing.

 

[dgezy]

Hi xladept,
I have dons some of that and am able to accomplish it one column at a time with the v-lookup function but it is way to time consuming to do on a daily basis. The fact that the supplier sheets keep changing I have had to rewrite the function each time. I will keep playing though.

Thanks
Dave

 

[xladept]

Hi dgezy,

That's why I used the UDT, you might consider it again!