This is bit tricky,This BOT is going to be run for every one hour i have 2 excel sheet. Every one hour i’m downloading one particular excel sheet fowhich is like shown below. Consider it as Source_data
In the below excel sheet,I’m maintaining in some folder consider it as Output_data, I want to update the details of Counter from above sheet in the hourly column for every hour by Vlookup/Comparing Inline column.
How to automate this?
Considering the Bot is going to run every hour:
you can add a new column on each run.
For eg: you added a column named 03:00
Now loop through all the rows in your dataTable,
Update the values as you receive from source and update it in the column
This way you can get your desired output in simpler way.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.