Results 1 to 11 of 11

Is there a way to simplify my code?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-12-2010
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    189

    Is there a way to simplify my code?

    Hi,

    I have a spreadsheet which needs to perform the following actions
    1.) base on two range value (in Col A and B) in Worksheet1 to search and find the same value in Worksheet2 to Worksheet5
    2.) if can match the the value of WS1 in any of WS2 to WS5, then Copy particular cells from one of these WS to WS1

    My problem is that in reality, I got around 5000 row data in each WS2 to WS5 and around 1000 row data in WS1. I did try the code in the attachment, but it takes 38 seconds to fill just 27 rows.

    Can anyone tell me how should I simplify the code so that it can run faster.
    Thanks
    Attached Files Attached Files
    Last edited by lubbamkt; 06-09-2014 at 09:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to simplify code?
    By RaquelAR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2013, 07:30 AM
  2. [SOLVED] Simplify VBA Code
    By Sky188 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2012, 02:31 PM
  3. hi can anyone simplify this old bit of code
    By khalid79m in forum Excel General
    Replies: 3
    Last Post: 12-28-2006, 01:04 PM
  4. [SOLVED] Simplify Code
    By Soniya in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2006, 01:59 PM
  5. Simplify this code
    By Scott in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2006, 12:00 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