To:
KeepITcool

Thanks for your concern and help.

As I have no knowledge on VBA and thus after receiving your code,
borrowed a book and ran thru it hoping to learn proper place fo
substitutions.
but still in vain.

Q1: You mentioned about the name of the Quesrytable.
Is it the name I put at random when setting the Properties ,e.g.
sort.cfm "?
or
the full http:// .... ... where the table come from ?

Q2: I have a few pairs of work sheets to do similar task.
Do we have to specify the source and target name(s) ?


Q3: Does your code allow source range be copied to specified targe
range at every interval set ?

Await for your comment while I am still doing my book running.

Eduard

--
EduardoDo
-----------------------------------------------------------------------
EduardoDon's Profile: http://www.excelforum.com/member.php...nfo&userid=849
View this thread: http://www.excelforum.com/showthread.php?threadid=26857