I have two excel spreadsheets. One is an exported SQL database into Excel.
In workbook one i have itemnmbr, prclevel and uomprice (the important fields). The UOMPRICE is the field that needs to be updated.
In workbook two I have Column A (item), Column D (1-10), Column E (11-50), Column F (51-100), and Column G (101=)
The identified from workbook one would be ITEMNMBR and PRCLEVEL ( the PRCLEVEL shows a text description like 1-10, 11-50, 51-100, and OVER 100)
I do n ot know an easy way to related it to update workbook one with the columns from workbook two.
I have attached a sample file showing the two workbooks; However due to experts exchange i had to combine the files. Worksheet 1 and Worksheet 2
Can anyone help?