I have another question. If i have a workseet which gets its all the
data from AS/400 and i want to transfer all that data  to another
sheet, how can i do it programmatically. Can you please guide me on
that. Basically the whole idea is to copy all the information from one
sheet to another, So that whenever the first sheet  is refreshed, the
data on the second sheet gets refreshed automatically. Thanks. I will
really appreciate that.