I am looking to create a macro that will look at cells in one workbook and create one code in another workbook. The EFCodeCompare workbook has the information for the codes and the EF-FinalBook has the workbook where I'd like to add two columns (ItemCode and Classification) The item code looks at the EFCodeCompare for the cells in "Spec" and then the "Class" and then the "Size" example 5EE-0450-0020 and pastes it to the corresponding row under ItemCode in EF-FinalBook. It also looks at the "Desc" row and adds the new "Class" Row. I hope these two workbooks clear up what I'm looking for...
Thank you!!
Bookmarks