Recording data from refreshing, imported sheets
 

::

Hi there,


Looking for HELP on VB code for the following:


I need to record data from dynamic , refreshing imported sheets t
other sheets as record on various time intervals.


Say,

i) ‘r1’ is an imported sheet refreshing every 60 minutes ;
set by ---- Data Import External Data Data Rang
Properties Refresh every 60 minutes

ii) ‘Sr1’ is a recording sheet in match with sheet ‘r1’;

iii) Need to transfer/record cells M4:M17 and N4:N17 to cells J4:J1
and J20:J33 respectively.

iv) For every consecutive 180 minutes, records will be copied t
consecutive cells on sheet ‘Sr1’ such as


............................................data in cells M4:M17 an
N4:N17 of sheet ‘r1’
......60 minutes after :.......copied to cells K4:K17 and K20:K33
respectively on sheet ‘Sr1’;
2 x 60 minutes after :.......copied to cells L4:L17 and L20:L33
respectively on sheet ‘Sr1’;
3 x 60 minutes after :.......copied to cells M4:M17 and M20:M33
respectively on sheet ‘Sr1’;

and so on for 24 hours (i.e. 24 records)


Would appreciate help with appropriate VB code to do the job.


v) at cell Q4 of sheet‘r1’, I have a [ =NOW() ]
can I also have the exact time of every recording be placed a
J3 ( K3, L3, M3, N3, ….) of sheet ‘ Sr1’ ?

vi) I have about 8 ~ 10 imported sheets set to refresh at almost th
same time.
Obviously there will be some hindrances if all of them refresh
record simultaneously.

Will there be any VB code telling them to DO one after th
completion of the other ?



Thanks in advance for any assistance.

EduardoD.
2004-10-10
:

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

Recording data from refreshing, imported sheets
 

hi,
look up OnTime Method time in vb help.
see the following sites.
http://www.enhanceddatasystems.com/E...ExcelTimer.htm
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/events.htm
http://www.rondebruin.nl/copy5.htm

-----Original Message-----

::

Hi there,


Looking for HELP on VB code for the following:


I need to record data from dynamic , refreshing imported
sheets to
other sheets as record on various time intervals.


Say,

i) 'r1' is an imported sheet refreshing every 60
minutes ;
set by ---- Data Import External Data Data Range
Properties Refresh every 60 minutes

ii) 'Sr1' is a recording sheet in match with
sheet 'r1';

iii) Need to transfer/record cells M4:M17 and N4:N17
to cells J4:J17
and J20:J33 respectively.

iv) For every consecutive 180 minutes, records will be
copied to
consecutive cells on sheet 'Sr1' such as


............................................dat a in
cells M4:M17 and
N4:N17 of sheet 'r1'
......60 minutes after :.......copied to cells K4:K17
and K20:K33
respectively on sheet 'Sr1';
2 x 60 minutes after :.......copied to cells L4:L17
and L20:L33
respectively on sheet 'Sr1';
3 x 60 minutes after :.......copied to cells M4:M17
and M20:M33
respectively on sheet 'Sr1';

and so on for 24 hours (i.e. 24 records)


Would appreciate help with appropriate VB code to do the
job.


v) at cell Q4 of sheet'r1', I have a [ =NOW() ]
can I also have the exact time of every recording be
placed at
J3 ( K3, L3, M3, N3, ..) of sheet ' Sr1' ?

vi) I have about 8 ~ 10 imported sheets set to refresh
at almost the
same time.
Obviously there will be some hindrances if all of them
refresh /
record simultaneously.

Will there be any VB code telling them to DO one after
the
completion of the other ?



Thanks in advance for any assistance.

EduardoD.
2004-10-10
::


--
EduardoDon
---------------------------------------------------------
---------------
EduardoDon's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=8492
View this thread:
http://www.excelforum.com/showthread...hreadid=267988

.