Hi All,
I am having a Master Excel file that needs to be fill in everyday using the date as the refference . I need the Bot to find the correct cell value before entering the amount into the column. For Example the excel has 3 column (Date, Sales, Refunds) Date information is fixed from 1st to 31st every month, if i need to fill up Sales value on 12-Jan for example how can the bot find the cell reference to enter the value .
I am having a Master Excel file that needs to be fill in everyday using the date as the refference . I need the Bot to find the correct cell value before entering the amount into the column. For Example the excel has 3 column (Date, Sales, Refunds) Date information is fixed from 1st to 31st every month, if i need to fill up Sales value on 12-Jan for example how can the bot find the cell reference to enter the value .