Hello,
I have been trying to wrap my brain around a problem regarding dividing two columns (in a range), by eachother to create a column for percentages. (ie. Column B/Column C = Percentage in column D).
The problem is that in one workbook it works GREAT as it uses relative cells. However, in a newer workbook I have it doesn't work properly despite identical code.
The Code is :
In this workbook Diabetes test - testingHelp2.xlsm It does not work as it should.
However, in this workbook it does work Diabetes test - testingHelp2 - Copy (2).xlsm despite identical code
Things to know:
- The macro that runs it is called "Report"
- The code is under the comment "Calculates the Percentage of A1C <= 0.07 within 6 months for each doctor"
-The percent displays in "sheet2" in column D
Bookmarks