Mark,
Thanks. Am still trying. Now am using DSTDEV(database,field,criteria) but
got stuck with criteria and not sure if this function is appropriate.
Carlos
"Max" wrote:
Apologies, I'm out of suggestions to offer you, Carlos.
Perhaps others may step in with something for you.
Hang around awhile. All the best.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Carlos" wrote in message
...
Max,
Appreciate your advice. I have thought of this before posting to the
group.
I would have around 20 worksheets in one file and each worksheet would
contain thousands of records. I have found this approach time consuming.
Carlos