+ Reply to Thread
Results 1 to 9 of 9

Re organize data in excel in VBA

  1. 11-15-2019, 12:36 PM #1
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re organize data in excel in VBA

    Hi Guys

    I have raw data in Sheet1, I want organize these data in Sheet2.
    Raw data is quiet unorganized.

    How can I do this in VBA?

    Here below the raw data in Sheet1
    example 01.JPG

    What I want in Sheet2.
    example 02.jpg
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-15-2019, 03:42 PM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Re organize data in excel in VBA

    Do you really want to have the 3 reports in the same columns ???
    It will not help a lot for filter and Pivot Table: Why not all in the rows .. side to side ??
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 11-15-2019, 03:58 PM #3
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41
    Quote Originally Posted by PCI View Post
    Do you really want to have the 3 reports in the same columns ???
    It will not help a lot for filter and Pivot Table: Why not all in the rows .. side to side ??
    Thanks for your reply, but I am really looking for the output as I request in my post, if it's possible.
    Reply With QuoteRegister To Reply
  4. 11-15-2019, 06:40 PM #4
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Re organize data in excel in VBA

    See how next code can help
    To be launched from sheet "Sheet1"
    Please Login or Register  to view this content.
    Last edited by PCI; 11-15-2019 at 06:42 PM.
    Reply With QuoteRegister To Reply
  5. 11-15-2019, 06:59 PM #5
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: Re organize data in excel in VBA

    Thank you very much for your help.
    Reply With QuoteRegister To Reply
  6. 11-15-2019, 06:59 PM #6
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Re organize data in excel in VBA

    A remake with a nicer result ...!
    Please Login or Register  to view this content.
    Last edited by PCI; 11-15-2019 at 07:01 PM.
    Reply With QuoteRegister To Reply
  7. 11-15-2019, 07:00 PM #7
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Re organize data in excel in VBA

    You're welcome and thanks for the Rep.
    Enjoy Excel
    Reply With QuoteRegister To Reply
  8. 11-15-2019, 07:02 PM #8
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: Re organize data in excel in VBA

    Many thanks again.
    Reply With QuoteRegister To Reply
  9. 11-30-2019, 05:17 AM #9
    mehidy1437
    mehidy1437 is offline
    Registered User
    Join Date
    09-12-2019
    Location
    Bnagladesh
    MS-Off Ver
    2013
    Posts
    41

    Re: Re organize data in excel in VBA

    Quote Originally Posted by PCI View Post
    You're welcome and thanks for the Rep.
    Enjoy Excel
    hi, I have modified the code a bit, here below the details.

    01.I have added data in two more column.
    02.I'm repeting the the cell g6:k6 under "Body" column in sheet2.

    Please check below & advse, if its correct way or not?
    Please Login or Register  to view this content.
    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. Organize and Sum Data
    By showboat in forum Excel Programming / VBA / Macros
    Replies: 55
    Last Post: 04-23-2018, 04:15 PM
  2. Excel macro to copy and organize data.
    By novice_excel_2017 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2017, 04:00 PM
  3. Can I use Excel to organize this data into lists?
    By Zierra in forum Excel General
    Replies: 2
    Last Post: 11-01-2013, 06:00 PM
  4. [SOLVED] Excel vba copy data from general sheets and organize them in separate sheets.
    By excelsubb in forum Excel Programming / VBA / Macros
    Replies: 40
    Last Post: 01-24-2013, 08:01 AM
  5. Issues with how to create a Macro that organize data from one excel file into another file
    By chuchar7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2012, 10:56 AM
  6. how to organize the data ?
    By eran3185 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-21-2010, 04:49 AM
  7. How to organize this data?
    By adroadster in forum Excel General
    Replies: 3
    Last Post: 01-11-2009, 05:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1