I have to perform formulae in sheet1 excel where it has to select two cells from sheet2 and this it has to do for all the rows count that are available in sheet2. Here the rows are dynamic.
The formula is like this " =IF(Sheet2!A2,Sheet2!D2," “)” and this has to get continue till all rows are done.
I tried using UiPath but able to write value in cell but not getting output.
PLease help me to complete it using macros and UiPath both.
Hi Sreelatha,
Thanks for the reply, I tried the way that you suggested, it works when we apply formulae directly.
But when we apply dynamic value those are not working.
Will this work dynamically like below:
“=IF(”+“'”+ sheetname+“”+“'!A”+“”+ rowindex.tostring+“,”+“'”+ sheetname+“”+“'!D”+“”+ rowindex.tostring+“,”+“”" “”"
here sheename= excel sheetname
rowindex= the cell from which we have to get info .
Hi Lakshman,
Thanks for your reply, I tried with your suggestion, but when trying dynamically the formulae is not working. I tried like below:
“=IF(”+“'”+ sheetname+“”+“'!A”+“”+ rowindex.tostring+“,”+“'”+ sheetname+“”+“'!A”+“”+ rowindex.tostring+“,”+“”" “”"