Dear Sir,
In the attached excel sheet on the Tube feed page, cell B5 to get the ideal body weight from the list in the "IdealBodyWeight" sheet depending on the gender seclted (in the cell "E2") and the height (noted in "B3"). In the reference list, the height is in "inches" and our input is in...
Dear Sir,
Once I have the format ready will be stored in the multiple systems in the different wards. Since the formulas may get deleted accidentally, I am opting for VBA for stability. Also we have a plan to store the data to analyse the patient's progress. For that, we are trying u to use VBA...
Dear Sir,
I am engaged in a cancer management setup and am preparing an excel for calculating nutrition requirements for our patients. I have the excel sheet and am struck at calculating the water requirement. The theory for the calculation of water requirement is "4 mL / kg / hour for the first...
Hi,
I have the following code, provided by an expert from ExcelForum web site,which allows me to randomly choose numbers( as much required ) from a set of data available in column A.
==============================================================
Sub test()
Dim myMax As Long, a, i As Long...