clhare
02-06-2009, 10:56 AM
I need help inserting the following formulas into all rows of a particular column using a macro. I generally do not work in Excel at all, so I don't have any idea how to do this.
Here's the two formulas I need to insert in all rows starting with row 3:
Formula #1 -- Insert in all rows of column X
=IF(S3,"No Answer",IF(T3,"Left Message",IF(U3,"Wrong Number",IF(V3,"Reached",IF(W3,"Busy","")))))
Formula #2 -- Insert in all rows of column Y
=IF(S3,S3,IF(T3,T3,IF(U3,U3,IF(V3,V3,IF(W3,W3,"")))))
I have no clue what these formulas are even doing. I just know they exist in the original file and the macro I am updating creates a new file. I need the macro to also add these two formulas to columns X and Y of the new file.
I really appreciate any help!
Here's the two formulas I need to insert in all rows starting with row 3:
Formula #1 -- Insert in all rows of column X
=IF(S3,"No Answer",IF(T3,"Left Message",IF(U3,"Wrong Number",IF(V3,"Reached",IF(W3,"Busy","")))))
Formula #2 -- Insert in all rows of column Y
=IF(S3,S3,IF(T3,T3,IF(U3,U3,IF(V3,V3,IF(W3,W3,"")))))
I have no clue what these formulas are even doing. I just know they exist in the original file and the macro I am updating creates a new file. I need the macro to also add these two formulas to columns X and Y of the new file.
I really appreciate any help!