I need some help converting some formulas to a single macro.
I have a work sheet that has, we'll say 6 columns, for example I'll use 1 row, but i need it for the whole column
A thru F
I need a macro to perfrom the following functions
A1 =IF(F1>=2,"x"," ")
B1 =IF(F1>=3,"x"," ")
C1 =IF(F1>=6,"x"," ")
D1 =IF(F1>=9,"x"," ")
E1 =IF(F1>=12,"x"," ")
Any help on this would be greatly appreciated, I have searched for it, but I either can't find anything or am unsure what terms I should be searching for.
I have a work sheet that has, we'll say 6 columns, for example I'll use 1 row, but i need it for the whole column
A thru F
I need a macro to perfrom the following functions
A1 =IF(F1>=2,"x"," ")
B1 =IF(F1>=3,"x"," ")
C1 =IF(F1>=6,"x"," ")
D1 =IF(F1>=9,"x"," ")
E1 =IF(F1>=12,"x"," ")
Any help on this would be greatly appreciated, I have searched for it, but I either can't find anything or am unsure what terms I should be searching for.