You're not getting a response because no one has any idea what you want to
do. What do you want to happen when you say "refreshed"? What do you want
"accumulated"? What is "all the data"?
Imagine that some one walks in off the street, knows nothing about you or
what you are wanting to do, and he reads what you wrote. Do you think he
would be able to accomplish what you want? HTH Otto
"Hardik" wrote in message
...
I want to import data, which is one row, from one sheet to the other and
the
data should be refreshed whenever i open the file.
Also after transferring the data from one sheet to the other, i want to
accumulate all the data into one excel document.
How do i do that?
Plz respond fast.
Thx