Hi there
Looking for some help - at the moment I have a VBA code to insert a formula into a cell (J5) . That formula is below .....
What I am looking to do is have the Macro
1) Calculate the total number of rows which have some data in them in Column C
2) Copy the below formula down from J5 .. to J-123 .. (whatever row 123 is as defined by step 1)
Here is my current formula which just enters the formula into cell J5 only
Worksheets(“Data”).Range(“J5”).Formula = "=IF(H5=""a"",I5*(1-Master!$C$5),IF(H5="”b”",I5*(1+Master!$C$5)))"
Any help much appreciated !! Thank you in advance !!!
Looking for some help - at the moment I have a VBA code to insert a formula into a cell (J5) . That formula is below .....
What I am looking to do is have the Macro
1) Calculate the total number of rows which have some data in them in Column C
2) Copy the below formula down from J5 .. to J-123 .. (whatever row 123 is as defined by step 1)
Here is my current formula which just enters the formula into cell J5 only
Worksheets(“Data”).Range(“J5”).Formula = "=IF(H5=""a"",I5*(1-Master!$C$5),IF(H5="”b”",I5*(1+Master!$C$5)))"
Any help much appreciated !! Thank you in advance !!!