I have a predefined excel sheet (Sheet 1) with names and suffix and am scraping data from a website and buliding a datatable (Sheet 2) from it.
Items scraped (sheet 2) are matched against items in sheet 1 and processing is done. For that particular item a document is downloaded and when naming it I want it add the respective suffix for particular item (sheet 1) to the item. Say for example if item Delhi is matched between the sheets and the
downloaded document will have the name “XYZ” + DE.Sheet 1.xlsx (8.6 KB)