How To Find Excel Cell Referrence in Blue Prism

[Raysen16]

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 .

 

[ewilson]

In the Excel VBO there's an action called Find in Worksheet. You can use that to search for specified text within a worksheet and limit the range to search. In this case, you could limit it to column B.

Cheers,
Eric

 

[Pete_L]

If we assume that the day of the worksheet always has 3 header rows, then the row corresponding to any given date is date+3. You can use that logic to find the correct row and go from there.