hello, i have the question, how to open a certain PDF file with certain “values” that result from an Excel column and then copy values from it and paste them into certain cells of the Excel file.
The following screenshot illustrates my intention:
I had thought about solving the whole thing with an “if condition” by saying “if the column name is equal to xy and the value of the row in it is equal to the last three characters of a pdf name inside the folder”, then “open the pdf and copy three specific values into selected cells of the row” and else "if the pdf is not found write “no” into another cell of the row. I would have to do the whole thing with a loop for all rows of the column.
unfortunately i’m still a beginner and don’t know the terms for something like that yet and couldn’t find it in the forum.