I have data from excel that I need to input into a web form to search a database. The results I then “save as” to a local folder, but the file name needs to be one of the values that is in the excel row.
You can use LookUp Range For searching name in excel sheet
Once you find that name output will give you Cell No say B23
Then u can use Cell A23 as your file name for saving