Use the macro recorder for VBA code for a relative formula

I did this very thing today, so thought I would share this tip with you as it saved me a lot of time.   Say you wanted to have this formula go into column 8 of the range you created in VBA for the number of dynamic rows you extracted using Advanced Filter. =CHOOSE( OR(C6={“EL”,”IL”})*1+(C6=”MT”)*2+OR(C6={“IP”,”EP”})*3+(C6=”SC”)*4+(C6=”AD”)*5, “Labour”,”Materials”,”Plant”,”SubContract”,”Overheads”) …

Use the macro recorder for VBA code for a relative formula Read More »