Help with VBA to calculate percentage and populate result in another Excel worksheet

300zx

New member
Joined
May 16, 2013
Messages
3
Reaction score
0
Points
0
Hi, please write a VBA code for me to calculate Calculate percentage and populate result in another Excel worksheet. I have put all the details in the excel file explaining how I do it manually. Please see file "VBACodeQuery4.xlsm" attached. Thanks in advance for your help.View attachment VBACodeQuery4.xlsm
 

300zx

New member
Joined
May 16, 2013
Messages
3
Reaction score
0
Points
0
Hi Roy, I am not sure what you suggested but you only said "Hope it helps". The reason for using VBA is Excel have limitation on number of formula one can use in one worksheet. At some point it gives error 4004 or something. I have thousands of records and Excel cannot populate them all, it would populate a bit more than 50% of records. The only way around it is by creating a VBA. Thanks.
 

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
I said why would you need VBA for this?

VBA would not be faster than inbuilt Excel formulas, in fact it would be slower.
 

300zx

New member
Joined
May 16, 2013
Messages
3
Reaction score
0
Points
0
Oh Sorry Roy I didn't realize "Hope that helps" is part of your signature. If it works and has no limitation then I am Ok with. Can you help me on this? Thanks.
 
Top