Excel data extract from a refreshable query and from multiple tabs

Hello, I have a refreshable excel query with 3 different application tabs consisting of user name columns (first name, last name and user IDs) and I want the bot to go in there and search for a specific name with either of these parameters in each of the 3 tabs.
And then I want the bot to send a notification with the output results. How do I go about doing that in the simplest way? Struggling !!

@SG5

If possible, can you share excel query and file with dummy data privately. I’ll have a look and get back to you in case of any update.

1 Like