Results 1 to 9 of 9

Macro to Search(Find) specific word from list, and copy a cell referenced from each

Threaded View

  1. #7
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Macro to Search(Find) specific word from list, and copy a cell referenced from each

    I am very coffee sensitive person. I am afraid, the latte and coffee of Starbucks are VERY Dreadful. Coffee making is not a formula, but an art. If you have local Italian coffee shop, I will have a Weak latte.
     With Worksheets("NoRetention")
        x = .Range("K1:S" & .Range("K" & .Rows.Count).End(xlUp).Row)
     End With
    Column K is the first column and S is the last one. I am normally lazy and use Current region, but not in this instance as you have complete blank columns.
    Assigning(Copying) the range in to an array called X and this speeds the execution of the code.
    Dictionary holds unique keys with items.
    Loop through the array(X) and test each row for existence of a key. But the actual code is more complicated than merely looping through arrays.
    Before you venture out in the world of dictionary, it is a good idea to have a solid grasp of Arrays.
    Last edited by AB33; 10-28-2013 at 06:04 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Macro for search specific word and input specific value
    By Toton6868 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-10-2013, 07:14 AM
  2. Macro to search sheet for certain criteria and copy specific data to cell
    By ThaGonz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2012, 12:34 PM
  3. Replies: 13
    Last Post: 08-04-2011, 09:41 AM
  4. Replies: 1
    Last Post: 01-25-2011, 10:50 PM
  5. search for a specific word and copy the word and the preceeding words until a comma
    By DHANANJAY in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-31-2005, 09:10 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