Results 1 to 15 of 15

Reformat data in specific way using filter and split to two groups

Threaded View

YasserKhalil Reformat data in specific way... 09-08-2016, 07:18 PM
Richard Buttrey Re: Reformat data in specific... 09-08-2016, 07:53 PM
jindon Re: Reformat data in specific... 09-08-2016, 07:59 PM
YasserKhalil Re: Reformat data in specific... 09-08-2016, 08:59 PM
jindon Re: Reformat data in specific... 09-08-2016, 09:16 PM
YasserKhalil Re: Reformat data in specific... 09-08-2016, 09:53 PM
jindon Re: Reformat data in specific... 09-08-2016, 10:08 PM
sanram Re: Reformat data in specific... 09-08-2016, 11:01 PM
YasserKhalil Re: Reformat data in specific... 09-09-2016, 04:46 AM
sanram Re: Reformat data in specific... 09-09-2016, 07:27 AM
YasserKhalil Re: Reformat data in specific... 09-09-2016, 10:45 AM
YasserKhalil Re: Reformat data in specific... 09-09-2016, 03:22 PM
sanram Re: Reformat data in specific... 09-09-2016, 03:40 PM
YasserKhalil Re: Reformat data in specific... 09-09-2016, 04:48 PM
sanram Re: Reformat data in specific... 09-09-2016, 06:26 PM
  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Reformat data in specific way using filter and split to two groups

    Hello everyone
    I have two sheets .. the first is for raw data which is needed to be formatted in specific way
    Sheet2 is the result sheet .. I will explain what is fixed and what is to be changed

    In sheet2, the cell M2 I will put a value from sheet1 column D (Here's as example 1 or 2) suppose I type 1 in M2

    The headers from rows (5 : 10) to be copied again but there after the first group data with five rows (five blank rows in between the two groups)
    As for headers the colored cells will be changed :
    ** J5 & J26 will be the same value as M2
    ** K5 will be the string "A's Group" & K26 will be the string "B's Group"
    ** L5 & L26 will have the total of results (as explained in the attachment)

    As for the data it will not be exactly as the raw data .. notice the columns positions
    and as for the column A in sheet 1 is just numbering and in the result sheet I need to number filtered data

    NB : The data would be put after the header but let blank row as illustrated

    Hope it is clear and easy
    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 01-05-2015, 08:29 PM
  2. Need a Macro to Filter out certain groups of data
    By XIGRIMxREAPERIX in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2014, 05:13 PM
  3. Filter data by different groups of values
    By adriannn87 in forum Excel General
    Replies: 1
    Last Post: 05-16-2014, 12:57 PM
  4. Quick Macro to Reformat Data into specific format
    By Seraph122 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-23-2012, 07:13 AM
  5. Split Data into User Defined Groups
    By clacketyclack in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2012, 04:37 PM
  6. How to split data to reformat for comparison
    By Opy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2012, 10:52 PM
  7. Replies: 0
    Last Post: 01-19-2011, 02:28 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