Results 1 to 19 of 19

Macro for copying the value of one Cell to another cell(s) in specific time interval

Threaded View

  1. #1
    Registered User
    Join Date
    07-15-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    17

    Macro for copying the value of one Cell to another cell(s) in specific time interval

    Hi, I am new to this Forum and also in writing Macros.

    So, I have managed to write this Macro to copy the value of J2 to K2 and subsequently to L2..M2..N2... where the updated value of J2 is being recorded in subsequent cells at 1 minute's interval.

    Sub MntCalculate()
    lc = Cells(2, Columns.Count).End(xlToLeft).Column + 1
    If lc < 11 Then lc = 11
    For i = 0 To 0
    Cells(i + 2, lc) = Range("J2")
    Next i
    Application.OnTime Now + TimeValue("00:01:00"), "Sheet1.MntCalculate"
    End Sub

    My question is, how do I now modify this Macro to also copy the values of J3 to K3..L3..M3..N3.. and J4 to K4..L4..M4..N4... upto J218 to K218..L218..M218..N218... ?

    Thanks.
    Last edited by Swarnendu; 07-15-2017 at 03:55 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 19
    Last Post: 08-18-2021, 11:23 PM
  2. Interval Cell copying
    By jediknight in forum Excel General
    Replies: 2
    Last Post: 02-08-2015, 05:43 PM
  3. [SOLVED] look up cell value in time interval
    By Vestlink in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 03:00 AM
  4. Macro problem - copying specific cell's from one sheet to another
    By Mrgud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2012, 02:27 PM
  5. delete a specific cell value with interval
    By pani_hcu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-21-2011, 11:40 PM
  6. Macro for copying specific text from a cell
    By mvel_sky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2010, 02:47 AM
  7. copying cells at a specific interval
    By scareface in forum Excel General
    Replies: 5
    Last Post: 01-30-2007, 04:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1