Storing a name as a variable from a webpage and selecting the correct Excel sheet based on that variable


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.



If the name of the employee in the web based system and sheet name is same then you can use Write Range activity and in the Sheet name you can give the name as per the Web Based System

This may help you


1 Like