copy range of cells automatically to different range evry hr

try to put these two functions in your workbook under ThisWorkbook VBA project:

Please Login or Register  to view this content.

thnx for ur help

bt im nt dat familiar to vb ... so my file name is 24May 2011 nd i want to perform this function in Sheet2 ... nd can i change the hour thing to maybe halfnhour ...

thnx again i much appreciate ur help

if you want to change the sheet to sheet to just change the following line:

Please Login or Register  to view this content.

to change the hour to 30 minutes it is done by this function,, please change it in both subs.

Please Login or Register  to view this content.

ok i made a new workbook named ThisWorkbook
and i inserted ur code nd i changed the TimeSerial to ( 0 , 1 , 0 )
so i press the run button nd it copies d entire row instantly bt after 1 min a message comes 'cannot run the macro "c:\documents and settings\admin\.....\ThisWorkbook.xlsx'!ThisWorkBook.MoveColumn'.The Macro may not be available in this workbook or all macos maybe disabled.

also ,
a1:a50 has moving values
so will it copy the moving values or just the values at that particular time ??

first of all you don't have to name the workbook "ThisWorkbook" it is just an indication of the workbook in which t he code is written.
secondly you don't need a button to start the execution the code will start running as soon as the workbook opens.
please find attached a sample workbook for illustration.
note that the time is set to every 10 seconds just as an example. to change it to half hour please change the timeserial function as below:

Please Login or Register  to view this content.

thnx a lot sir
its working perfectly
one last thing , its nt copying just the value but the whole cell as it is

for eg a1 changes evry second or evry 10 seconds ... so will it be possible 2 copy just d value at x mins or seconds .

nd not the whole formula as it is .
thnx

If you want to copy just the values please change the MoveColumn Sub as follows:

Please Login or Register  to view this content.

woww .. thnx a lot sir
this has made a real difference in my worksheet

i just cant thank you enuf :D