+ Reply to Thread
Results 1 to 7 of 7

Need help on VBA code to split values from Col T criteria SEO with range

  1. 11-02-2022, 12:21 AM #1
    henrybrothers
    henrybrothers is offline
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Need help on VBA code to split values from Col T criteria SEO with range

    Hi experts

    i do need your help on code tried with autofilter on criteria range it takes alot of time to deliver and even not done task 100%

    please help on this
    Please Login or Register  to view this content.
    my requirement is copy data from sheet Task_RE On column T copy only SOE values with entire range A:BG
    paste into SOE_DATA

    once copy delete rows of SOE..
    Attached Files Attached Files
    Last edited by henrybrothers; 11-02-2022 at 12:21 AM. Reason: wrong title
    Reply With QuoteRegister To Reply
  2. 11-02-2022, 02:24 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: Need help on VBA code to split values from Col T criteria SEO with range 

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 11-02-2022, 02:46 AM #3
    vcoolio
    vcoolio is offline
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    1,098

    Re: Need help on VBA code to split values from Col T criteria SEO with range

    Hello Henry,

    Try the following:

    Please Login or Register  to view this content.
    I've used the sheet codes as per your sample to reference the worksheets, not the sheet names.

    I hope that this helps.

    Cheerio,
    vcoolio
    Reply With QuoteRegister To Reply
  4. 11-02-2022, 04:52 AM #4
    henrybrothers
    henrybrothers is offline
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need help on VBA code to split values from Col T criteria SEO with range

    HI sir I tried your code with 2 range criteria filter one after another, i got error can u help me with this
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by henrybrothers; 11-02-2022 at 04:53 AM. Reason: editing
    Reply With QuoteRegister To Reply
  5. 11-02-2022, 05:20 AM #5
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: Need help on VBA code to split values from Col T criteria SEO with range

    what has that code got to do with your sample upload???
    Anyway, that code does work...although it can be simplified...Something else going on in this new file you are referencing...
    Last edited by sintek; 11-02-2022 at 05:25 AM.
    Reply With QuoteRegister To Reply
  6. 11-02-2022, 07:11 AM #6
    henrybrothers
    henrybrothers is offline
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need help on VBA code to split values from Col T criteria SEO with range

    Thanks boss its solved,its working in New open workbook but its show error in actual file, look mystery or magic
    Reply With QuoteRegister To Reply
  7. 11-02-2022, 07:13 AM #7
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,234

    Re: Need help on VBA code to split values from Col T criteria SEO with range

    Glad you got it sorted...Tx for rep +
    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. [SOLVED] Need help with vba code to split C column as per criteria
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2022, 04:47 PM
  2. [SOLVED] Need an help of vba code to split data from col F:F depends upon list of short keys values
    By MicroTees in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-21-2022, 04:19 AM
  3. [SOLVED] VBA code to Split and Sort String Values
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2020, 02:46 AM
  4. Modify Excel Code to split multiple worksheets based on criteria
    By Masa1989 in forum Excel General
    Replies: 9
    Last Post: 04-05-2016, 03:45 AM
  5. [SOLVED] VBA code required to TRIM and SPLIT the selected Range (String)
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-20-2015, 04:04 AM
  6. how to convert excel split code to word split code
    By gsrikanth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2012, 07:56 AM
  7. copy, split and transpose a range of values
    By Lucas Budlong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-05-2006, 06:40 AM

Tags for this Thread

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