I want to know about vbscript with macros

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
i have two excel sheet in that one is filled of details like empname and shifttype. with this information i want to fill Rupees colum in second sheet condition is if shift a or b rupees 100 and if shift c rupees 400. I dont know to write a code in vbscript. please, help me to write the code.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
why do you want vb scrip
in sheet 2 in any cell type this formula

=IF(OR(Sheet1!B2="a",Sheet1!B2="b"),100,IF(Sheet1!B2="c",400,""))
if necessary copy this formula down