+ Reply to Thread
Results 1 to 2 of 2

Splitting excel data to multiple files based on empty row or cell containing value

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    israel
    MS-Off Ver
    2020
    Posts
    1

    Splitting excel data to multiple files based on empty row or cell containing value

    excel.JPG

    hi everyone
    need some help to split data into files based on empty row or cell containing value (see boxed value) which repeats itself in the data. the data which needs to be saved in another file is the data below the cell containing value(included) until next cell containing same value.

    thanks!

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: Splitting excel data to multiple files based on empty row or cell containing value

    Hi refaelw

    Welcome to the forum...Unfortunately images don't explain your requirement...Can you please upload a sample file depicting your actual file set-up...and explain in detail what you are wanting to achieve...
    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 to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Splitting excel data (.xls) into multiple files (.xls)
    By marcus74 in forum Excel General
    Replies: 1
    Last Post: 09-27-2017, 08:05 AM
  2. Splitting out Excel data to multiple files based on one column values
    By MetroBOS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-04-2015, 04:54 PM
  3. Splitting out Excel data to multiple files based on one column's values
    By MetroBOS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2015, 11:38 AM
  4. Splitting a Worsheet into multiple files based on Cell Value
    By Phil_Lloyd_1979 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-02-2014, 11:24 AM
  5. How do I combine splitting data into files then splitting the new files data into multiple
    By Lauraguthrie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2013, 01:18 PM
  6. [SOLVED] Getting Excel (via VBA Script) to import multiple textpad files in the next empty cell.
    By red_dot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2013, 05:49 AM
  7. Splitting out Excel data to multiple files based on one column's values
    By machos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2011, 08:55 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