I hope you are doing all wel! and I hope you guys can help me with my problem.
At this moment I have an Excel file which contains 7 columns: Group, hyperlink (Windows File path) and several data columns.
As you can see, the column “group” has three groups: Group 1, 2 and 3.
The name of the group has been changed, because it has some confidential data in it. That’s why i have renamed it to group 1,2, and 3. The group isn’t always the same. It depends each month.
How can the Robot distinguish the name of the group?
The main purpose of this Excel file is to copy only the test data (Column C till G) to the Excel file that is linked on the hyperlink (Column B).
To do that, the robot has to filter the group column and keep only Group 1 and copy the test data to another Excel file. After that, the robot has to filter and keep only group 2 and so on.
Like i said, the column group isn’t always the same, so it is harder to filter it out, if the robot doesn’t know which group contains in the column.
Thank you guys for taking the time and would love to hear to a solution!