Need to run macros for using formulae in excel for uipath

[deepaksvg99 (deepak)]

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.

I am enclosing the excel for reference
Macro_test.xlsx (102.6 KB)
:

Also please try to modify this macro with arguments that can pass value :
Sub Macro4()
’
’ Macro4 Macro
’

’
Range(“B2”).Select
ActiveCell.FormulaR1C1 = “=IF(Sheet2!RC[-1],Sheet2!RC[2],”" “”)"
Selection.AutoFill Destination:=Range(“B2:B20”), Type:=xlFillDefault
Range(“B2:B20”).Select
End Sub

Here sheetname, rowindex and range index is dynamic but rows i.e A,B are static

[Sreelatha278 (Sree Latha Reddy)]

Hello @deepaksvg99 ,

To add the formula in Excel , use write cell as shown below.

[lrtetala (Lakshman Reddy)]

Hi @deepaksvg99

Try this way

After giving formula in Write Cell use Auto Fill activity to fill the total rows in that column.

I hope it helps!!

[deepaksvg99 (deepak)]

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 .

[deepaksvg99 (deepak)]

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+“,”+“”" “”"

Can you please check it

[lrtetala (Lakshman Reddy)]

Hi @deepaksvg99

Please find the below xaml

2 Methods are done (Static and Dynamic Values)

VLOOKUP Task.xaml (18.5 KB)

O/P:
Macro_test.xlsx (133.2 KB)

Regards,

[lrtetala (Lakshman Reddy)]

@deepaksvg99

If you find the solution for your issue. Please mark it as solution to close the thread and others also helped.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards,