I am working on a project to automate copy and pasting statistics from our web based system to an excel file. Statistics are relevant to each employee, and is pasted into that person’s specific excel sheet. All names are within the same Excel file but different sheets.
The issue I am having is getting the bot to recognise which name it is currently reading and choosing the correct Excel sheet to copy the data into.
Just need to be pointed in the right direction, any help will be beneficial.