The code is brilliant and worked like a magic on my database. I have a small
problem, though:
I have a raw in the patient sheets that contains a formula to return a value
(example: takes calcium level and multiplies it by phosphorous to get a
product value CaxP, which is a number of 2 decimals). Is there an easy fix to
the code to pastes the value into the summary sheet Table10 rather than the
content of the cell itself (which is a formula)?
Thanks a lot
Wissam

"Herbert Seidenberg" wrote:

Excel 2007 Tables
% of patients per test, per month, per limits
http://www.mediafire.com/file/gjlkwm...01_20_10a.xlsm
.