vba code

%3CLINGO-SUB%20id%3D%22lingo-sub-2716543%22%20slang%3D%22en-US%22%3Evba%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2716543%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20please%20help%20in%20turning%20the%20attached%20file%20for%20calculations%20on%20column%20G%3AK%20into%20a%20vba%20code%20to%20so%20that%20i%20can%20also%20reduce%20the%20file%20size%20because%20the%20file%20need%20to%20run%20for%20more%20that%20100k%20members%20from%202017%20-%202021.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2716543%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2722826%22%20slang%3D%22en-US%22%3ERe%3A%20vba%20code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2722826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1145789%22%20target%3D%22_blank%22%3E%40mmtawali%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20simpler%20formulas%20would%20make%20it%20work.%20See%20the%20attached.%20I%20was%20able%20to%20replicate%20your%20results%20without%20such%20an%20elaborate%20formula.%20I'm%20not%20a%20VBA%20proponent%2C%20for%20the%20most%20part%2C%20having%20been%20convinced%20over%20many%20years%20that%20the%20right%20formula%20often%20(admittedly%20not%20always)%20is%20more%20efficient%20than%20the%20%22brute%20force%22%20method.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, please help in turning the attached file for calculations on column G:K into a vba code to so that i can also reduce the file size because the file need to run for more that 100k members from 2017 - 2021.

 

 

2 Replies

@mmtawali 

 

Perhaps simpler formulas would make it work. See the attached. I was able to replicate your results without such an elaborate formula. I'm not a VBA proponent, for the most part, having been convinced over many years that the right formula often (admittedly not always) is more efficient than the "brute force" method. 

 

Thanks @mathetes. I agree with your sentiments. I will take a look at it again.