+ Reply to Thread
Results 1 to 8 of 8

Pull selective codes macro

  1. 02-29-2016, 04:11 PM #1
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Pull selective codes macro

    A = data
    B = query can be 1o or more items long , this one with 2 items
    C = results manually typed , want macro to pull that

    Attached file
    Reply With QuoteRegister To Reply
  2. 02-29-2016, 04:12 PM #2
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Pull selective codes macro

    Since I cannot attach file Data column a1 downwards

    CL797C36
    CL797C37
    CL797C38
    CL797C39
    CL797C40
    CL797C41
    CL797RD36
    CL797RD37
    CL797RD38
    CL797RD39
    CL797RD40
    CL797RD41
    CL797TN36
    CL797TN37
    CL797TN38
    CL797TN39
    CL797TN40
    CL797TN41
    CL797A36
    CL797A37
    CL797A38
    CL797A39
    CL797A40
    CL797A41
    CL714A36
    CL714A37
    CL714A38
    CL714A39
    CL714A40
    CL714A41
    CL798BG36
    CL798BG37
    CL798BG38
    CL798BG39
    CL798BG40
    CL798BG41
    CL798C36
    CL798C37
    CL798C38
    CL798C39
    CL798C40
    CL798C41
    CL798RD36
    CL798RD37
    CL798RD38
    CL798RD39
    CL798RD40
    CL798RD41
    Reply With QuoteRegister To Reply
  3. 02-29-2016, 04:13 PM #3
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Pull selective codes macro

    Data on b1 and b2 as query

    CL797
    CL714
    Reply With QuoteRegister To Reply
  4. 02-29-2016, 04:13 PM #4
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Pull selective codes macro

    Data on c1 downwards should be results of macro

    CL797C36
    CL797C37
    CL797C38
    CL797C39
    CL797C40
    CL797C41
    CL797RD36
    CL797RD37
    CL797RD38
    CL797RD39
    CL797RD40
    CL797RD41
    CL797TN36
    CL797TN37
    CL797TN38
    CL797TN39
    CL797TN40
    CL797TN41
    CL714A36
    CL714A37
    CL714A38
    CL714A39
    CL714A40
    CL714A41
    Reply With QuoteRegister To Reply
  5. 03-01-2016, 12:00 AM #5
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Pull selective codes macro

    Macro to read a at rows infinity , data is long at 2o,ooo rows plus
    Reply With QuoteRegister To Reply
  6. 03-01-2016, 12:45 AM #6
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Pull selective codes macro

    This is a suitable job for AdvancedFilter :
    - Insert a new line at row 1
    - Enter the same string on cell A1, B1, C1 as the header (for example : Data)
    - Run the code below :

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 03-01-2016, 01:05 AM #7
    makinmomb
    makinmomb is offline
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: Pull selective codes macro

    Karedog , wow wow , does exactly what I need
    Reply With QuoteRegister To Reply
  8. 03-01-2016, 01:15 AM #8
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Pull selective codes macro

    You are welcome, thanks for the rep. points.


    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Selective Load Balancing Macro
    By Dissonant in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-12-2013, 11:43 PM
  2. [SOLVED] Updating selective codes with multiple rows
    By brandedadnan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-06-2013, 04:51 AM
  3. [SOLVED] replace selective codes
    By brandedadnan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-04-2013, 04:29 AM
  4. Macro to Pull Selective Data
    By Swordfish1989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2012, 08:37 PM
  5. Pull codes from list based on number of orders
    By cshort in forum Excel General
    Replies: 2
    Last Post: 10-20-2011, 11:01 AM
  6. Selective pull down menu
    By Kalberts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2011, 05:49 AM
  7. macro to retrieve selective files
    By jem4614 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-09-2008, 02:01 PM
  8. Selective Summing Macro
    By dwest200 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2008, 11:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1