No prob, thanks for posting back
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lamb Chop" wrote in message
...
Thanks you first, Max for your prompt reply. I was checking autofilter
and pivot table from the help to see if it is the key. I just want to
understand it before I reply. Unfortunately, autofilter and pivot are not
ones I need.

However, I found a new way to fix my problem which you may interested.
I created a csv file where I input the data. Then in excel under
Data,get external data and import text file, I can make it automatically
update the data every 5 minutes. For me, it is quite a new technique.

thanks again for your sharing, Max.

Choppy