+ Reply to Thread
Results 1 to 14 of 14

Need VBA code to split raw data to targeted workbook into worksheet depends upon col F:F

  1. #1
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Need VBA code to split raw data to targeted workbook into worksheet depends upon col F:F

    Dear experts

    I have data set A:H i want split particular col values depends upon key words match as prefix

    for e.g col F: prefix as Cancel,Suspension,Rejected,Out of Cash,Omission and only one value check is complete text "Acquisition-Cancellation Documentation and Media " split those data to target file in target path with particular sheets

    Target file at path is C:\Users\Windows 10\Unbilling_Data.xlsx

    Target sheet (Vendor_Cancel&Billing_suspend)

    find the attachment clear explanation give in sheet.

    expected result is Unbilling_Data.xlsx

    Thanks Heaps!!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    Hi boss I got error this
    Attached Images Attached Images

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    OK, try the attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    Sorry boss small requirement Unbilling file dont need to pop-up visibly update the Excel worksheet on your screen , i want Application.ScreenUpdating = off and save the file (Unbilling_Data.xlsx)

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    1) It's already there in the workbook I posted.
    2) Just delete apostrophe of the below the last End With. (Save line).

  7. #7
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    Thanks Expert Kudos to your help and effort

  8. #8
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    Hi Sir, Can u help me on code to add criteria key with code instead J9 range. more over i want delete data in source wb once copy to sheets.
    need to add with code
    Cancel,Suspension,Rejected,Out of Cash,Omission and Acquisition-Cancellation Documentation and Media

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    change to
    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    Thanks alot sir for coming back solved it my last question where do i make change in code if i want move filter column F to Z just point out it wrap code,

  11. #11
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    Not clear to me.
    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    No sir , i mean data filter happen from F:F column depends upon criteria list, so if move criteria column data to Z whhere i have to make changes in code
    code

    see the attachment file i moved f column to z
    Attached Files Attached Files

  13. #13
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    Use the code in post #9 and change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    10-16-2022
    Location
    australia
    MS-Off Ver
    2016
    Posts
    90

    Re: Need VBA code to split raw data to targeted workbook into worksheet depends upon col F

    Wow Amazing Code!!!!Kudos to guru thanks for your time and patience boss solved

+ 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. Help on VBA Code to split rows into newwb depends upon cell criterial
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2022, 12:49 AM
  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] Ensuring that VBA code runs on records in a targeted Excel Worksheet
    By patdools in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2019, 05:08 PM
  4. [SOLVED] need vba to split data move to particular file sheet depends upon sheetname
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-06-2016, 03:05 AM
  5. need vba code to split rows to closed wb shets depends company code met with sht name
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2016, 12:44 PM
  6. Vba macro to split the data to three sheets depends upon single & repeats
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2013, 10:54 AM
  7. [SOLVED] VBA Split Data and Move to targeted named file from master file
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-19-2013, 01:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1