Results 1 to 23 of 23

Optimized macro to run more efficiently

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2020
    Location
    USA
    MS-Off Ver
    365
    Posts
    11

    Optimized macro to run more efficiently

    Any help is appreciated!!!!
    I would like to make this run faster and more efficiently. It goes on to 16 more sheets with different cells and columns.

    Sub CopyData()
    Dim myDate As Date
    Dim myValue As Variant
    myDate = Worksheets("entry").Range("A1").Value
    
    'reading 1
    myValue = Worksheets("entry").Range("B3").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 4).Value = myValue
    'reading 2
    myValue = Worksheets("entry").Range("D3").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 6).Value = myValue
    'reading 3
    myValue = Worksheets("entry").Range("F3").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 8).Value = myValue
    'reading 4
    myValue = Worksheets("entry").Range("D6").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 10).Value = myValue
    'reading 5
    myValue = Worksheets("entry").Range("F6").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 11).Value = myValue
    'reading 6
    myValue = Worksheets("entry").Range("H6").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 12).Value = myValue
    'reading 7
    myValue = Worksheets("entry").Range("D8").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 13).Value = myValue
    'reading 8
    myValue = Worksheets("entry").Range("F8").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 14).Value = myValue
    'reading 9
    myValue = Worksheets("entry").Range("H8").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 15).Value = myValue
    'reading 10
    myValue = Worksheets("entry").Range("D10").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 16).Value = myValue
    'reading 11
    myValue = Worksheets("entry").Range("F10").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 17).Value = myValue
    'reading 12
    myValue = Worksheets("entry").Range("H10").Value
    Worksheets("sheet1").Range("A:A").Find(myDate).Offset(0, 18).Value = myValue
    Last edited by jeffreybrown; 03-12-2020 at 09:06 AM. Reason: Please use code tags!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Macro needs to be optimized (speed up the execution)
    By kevivu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2015, 06:20 AM
  2. Macro to run formulas more efficiently
    By Ale84 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2015, 06:55 PM
  3. Curious about a more optimized method
    By cman0 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2014, 07:40 PM
  4. [SOLVED] Macro to more efficiently copy/paste every 21 rows
    By Phil_Packer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-23-2013, 03:08 AM
  5. [SOLVED] Can this macro be written more efficiently?
    By alpinesd in forum Excel General
    Replies: 4
    Last Post: 06-16-2012, 02:46 AM
  6. Working Code: Can it be optimized?
    By qcity in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-17-2011, 01:00 AM
  7. Help to get Macro operating efficiently
    By mr_teacher in forum Excel General
    Replies: 4
    Last Post: 09-01-2006, 04:13 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