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