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