Data Scraping and Write to Excel Worksheet

[dwalker (Daragh Walker)]

Thanks @loginerror.

I have tried 10+ different methods to the following: I need to search for the value stored in one excel in the Nomenclature excel and then copy all rows back to the original excel.

It is explained in the link below if you have the time I appreciate it.

Thanks!

Search for excel row using value from datatable

Hi, I have two excel worksheets as data tables. The first data table called ‘GoodsCodes’ contains codes that will be used to search the Excel worksheet (As seen in the first screenshot in column A) What I want to do is use the values stored in Goods Codes, search NomenclatureInfo (data table of screenshot 2 worksheet) and then copy columns B-G which contains the goods code in column A. The output of this will be back into the first worksheets Column B ‘Description’. ie. Find the goods code num…