VBA vlookup drop down list

Hi, rs1aj,

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Maybe the macro can be based on the headers of the worksheets but I would need to see some information.

Ciao,
Holger

Hi, rs1aj,

thanks for the sample. Could you please indicate for how many different sheets this should be applied (this may determine if I will try using a lookup matrix or try to code in a macro)?

Will the description of the headings maybe differ on different items as UPC and Universal Product Code as it is right now? Where would I find Length/Width, Lbs, Pack Units for Vendor 1 or Our Cost, Pkg Height, and Case Qty for Vendor 2 in Master? What about the different costs, which column to take for which (maybe depending on quantity/forwarder/Express delivery)?

Sorry but these questions came up when I looked at the workbook supplied. I would be glad if you could try and point me into the direction.

Ciao,
Holger

Thank you for your help on this.

I will have up to 20 different Vendors submitting sheets similar to this. All of them basically want the same information...example...most all of them want the products height which is on my "Master Spreadsheet" in column G labeled "Pkg Height". One vendor will submit a sheet like "Vendor 1 Sheet", which is asking for that information in column F labeled "Hgt", the next vendor will submit a form like Vendor 2 Sheet wanting that same information but have it in column I and have it labeled "pkg height", which just so happens to match my label title from my "Master Spreadsheet". Some match my headers, most don't, and all of them are in different columns on their sheets.
All vendors need the cost, 5 of them will get "Cost 1" from my sheet, 7 will get "Cost 2", 4 will get "Cost 3" and so on based on who they are so I have to assign the correct cost column to them manually.
All vendors are asking for different products...example...Vendor 5 wants ten of my items and Vendor 12 wants 25 totally different items of mine, all are in different orders down column A on their sheets and sometimes a vendor has my part numbers listed down column F on their sheet. Of course, my "Master Spreadsheet" never changes and always has my part numbers in order down column A, which works well for vlookup purposes.

Hi, Vikas_Gautam,

Originally Posted by OP

and each spreadsheet from the customer is a little different.

Originally Posted by Vikas_Gautam

but you have to keep the same column headers as in the master sheet... to get the desired result...(hopefully you can do it..)

I´m glad you "solved" this problem although OP has mentioned different headings in each Vendor sheet.

Ciao,
Holger

Hi, rs1aj,

I´ve added a new sheet to the workbook called Tables. Please have a look at it as it holds the correlation between the information from your Master Spreadsheet and the individual Vendor Sheets which should be completed for the other sheets you have on hand. I marked two cells with yellow and question marks as I wasn´t able to guess at what values would be needed to be copied over there. For text for these cells would be "Please check!!!" unless you fill the cells with the proper columns.

The code I used is placed in ThisWorkbook:

Please Login or Register  to view this content.

Please take your time going through the code and to check if the result is near to what you want (and if you can add the information into Tables by yourself as needed).

Workbook attached.

Ciao,
Holger

Hi, Vikas_Gautam,

Got the new solution buddy..

Well, on Vendor 2 Sheet the Universal Product Code, Our Cost and Case Qty should be different from Part, same goes for Vendor 1 Sheet with Hgt, Length/Width, Lbs, and Pack Units. You should check before posting a workbook, not us!

Ciao,
Holger