>Thanks all of you for a quick reply and very professional way in our VFP forum. It works great.
>
>But this is only the beginning of the story, why ? because someone gave me
>an excel sheet exactly with the same question. Maybe I ask to the wrong forum to convert your wonderfull codes into VBA to do the same thing, then my headache will be absolutely over because I am newbie for Excel-VBA.
>
>Please do the impossible for me, really appreciated for any help you have
>provided so far.
>TIA
Paul, if it must be done in Excel itself or via Automation from VFP?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.