Need Macro Help

[suresh kannah]

can we write a macro to copy AV1 -AV46 from sheet 1 & paste in sheet 2 Av1-AV46 & Every 15 min copy data from AV1 -AV46 & paste to B1-B46, & C1-C46 & on every 15 min

Thanks In Advance
Suresh

Post moved by Moderator.


.

 

[p45cal]

can we write a macro to copy AV1 -AV46

Surely you meant you.
Try the following in your sample file.
Putting anything in A1 of Sheet2 will stop the repeating after the next copy/paste takes place.

Sub Macro1()
Set Destn = Sheets("Sheet2").Cells(1, Columns.Count).End(xlToLeft).Offset(, 1)
Sheets("Sheet1").Range("AV1:AV46").Copy
Destn.PasteSpecial Paste:=xlPasteValues
Destn.PasteSpecial Paste:=xlPasteFormats
If Destn.Parent.Cells(1, 1) = "" Then Application.OnTime Now + TimeValue("00:00:05"), "Macro1"
End Sub

Currently it repeats every 5 seconds for demo purposes. For a 15 minute interval change
("00:00:05")
to
("00:15:00")

 

[suresh kannah]

HI

I am New to macros can you please do it in the excel,
put this code and mail me the sheet,i tried it didnt work correctly.

Thanks for your time
Suresh

 

[p45cal]

Attached file with code, plus added a button on Sheet 2 to start it.

 

[suresh kannah]

thanks for the sheet and efforts,
do you do freelancing have couple more sheets,
can i have your contact no