+ Reply to Thread
Results 1 to 3 of 3

Could any one help make this macro with sheet lookup more efficient? (Google Sheets)

  1. #1
    Registered User
    Join Date
    10-21-2022
    Location
    Lincs, England
    MS-Off Ver
    Google Sheets
    Posts
    1

    Could any one help make this macro with sheet lookup more efficient? (Google Sheets)

    Hi! Could anyone please help make this function more efficient? Just to mention I'm not very good with code.

    This was mainly just done using the record a macro thing on Google Sheets, it's not very efficient. The problem is that I have hundreds of sheets so I believe when this macro is looking up a sheet by name each time it's very slow.

    Thanks a lot for any help.

    - Tess

    Please Login or Register  to view this content.
    Last edited by Snoozles; 10-21-2022 at 05:28 AM.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Could any one help make this macro with sheet lookup more efficient? (Google Sheets)


    Hi !

    Wrong forum ! As a reminder this is an Excel VBA only forum ...

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,388

    Re: Could any one help make this macro with sheet lookup more efficient? (Google Sheets)

    Thread moved to the correct sub-forum.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make Codename macro shorter & possibly more efficient
    By Dbroek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2021, 04:46 PM
  2. Make VBA Macro more efficient
    By boubou114 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2015, 10:32 AM
  3. [SOLVED] Make a macro more efficient/faster
    By jhonneyboy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-25-2014, 05:38 PM
  4. Make Copy/Paste Values Macro more efficient when calculating
    By Phily915 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2014, 04:28 PM
  5. Macro takes 20 seconds to run, can anyone please help to make it more efficient?
    By Adrian1981 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2013, 11:24 PM
  6. Macro takes 20 seconds to run, can anyone please help to make it more efficient?
    By Adrian1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2013, 06:44 PM
  7. [SOLVED] Stock In/Out Sheet - Help to make more efficient
    By JDobbsy1987 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-02-2013, 08:54 AM

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