Results 1 to 6 of 6

split data based on three columns to multiple sheets and rename sheets based on headers

Threaded View

KalilMe split data based on three... 08-09-2021, 05:13 AM
Marc L Hi ! Try this ! 08-09-2021, 06:32 AM
nankw83 Re: split data based on three... 08-09-2021, 07:10 AM
iustin Re: split data based on three... 08-09-2021, 07:43 AM
KalilMe Re: split data based on three... 08-09-2021, 08:32 AM
KalilMe Re: split data based on three... 08-09-2021, 08:35 AM
  1. #1
    Forum Contributor
    Join Date
    04-11-2021
    Location
    Tripoli
    MS-Off Ver
    Excel 2016 ,windows 10 64bit
    Posts
    409

    split data based on three columns to multiple sheets and rename sheets based on headers

    hi
    I have data in sheet MAIN the result should be after it so it should split data based on COL B,C,D and the sheets names should be based on headers when create the new sheets after split them . every time increase data in sheet MAIN then should updating in the created sheets . so the result in sheets IMPORT,EXPORT ,RETURNS
    sorry if it's poor detailes , but I think the result after sheet main will be clear . if it's not clear please inform me
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] split data across multiple sheets based on month
    By Alaa-A in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-10-2021, 06:54 AM
  2. [SOLVED] split data from sheet to three sheets for many names based on two columns
    By leap out in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-14-2021, 10:02 AM
  3. [SOLVED] Split one excel sheet into multiple sheets based on column value but only selected columns
    By nr6281 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-01-2019, 05:25 AM
  4. [SOLVED] Need VBA code to match the value and split the data in the multiple sheets based on column
    By Giri.hb in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-04-2016, 09:06 AM
  5. Need Macro code to split data split in 7 sheets based on variable rows in column A
    By Alija_21 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2015, 08:03 AM
  6. [SOLVED] Split excel data into multiple sheets based on Employee ID
    By Preeti1309 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-21-2014, 02:33 AM
  7. [SOLVED] How to Rename Multiple sheets using right function based on a cell
    By choleb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2013, 01:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1