I am working on a UC where BOT extract data from raw HTML file and writes it into Excel file.
But without automation, the excel that was maintained contained formulas to extract the same data that now BOT extracts via automation.
The bot will likely have to concatenate the pieces together before writing into the Excel workbook as they are in different data cells.
The formulas in columns A-D are substrings that extract the individual pieces of data .
And when the bot runs, it copies the completed worksheet into the workbook that the bot has created for the other two tabs.
Main agenda is to copy the formulas of the excel sheet i have uploaded to the new workbook ICOMS Errors.xlsx (19.9 KB) while creation of workbook.