+ Reply to Thread
Results 1 to 4 of 4

VBA Splitting DataSet across two DataSets

  1. #1
    Registered User
    Join Date
    01-14-2014
    Location
    perth
    MS-Off Ver
    Excel 2010
    Posts
    9

    VBA Splitting DataSet across two DataSets

    Hi,

    I have a spreadsheet with three sheets.
    Sheet #1 is the Input sheet.
    Sheet #2 and Sheet #3 are summaries (called 'Output-1' and 'Output-2').

    Sheet #1 has six columns (with headers), under each column there are letters.

    Task:

    I need the information in Sheet #1 to be split across the two summary sheets using VBA.

    For example:
    In column 1.1.1 on the Input sheet we have the values 'a','b','c','d',and 'e'.

    In the summary sheet 'Output-1' the value "1.1.1" needs to be put against 'a', 'c', and 'e'; and in summary sheet 'Output-2' the value "1.1.1" needs to be put against 'b' and 'd'.

    This needs to be done for all six columns shown on the Inputs sheet.

    Perceived Complications:
    - The data from the Input sheet needs to be split across two summary sheets depending on the values in the columns.

    - On the summary sheets, the values will need to be put into the next empty cell against the respective letter.

    Thank your for any help you may provide, and if I have been unclear in any way please ask for more information.

    Have a wonderful day,

    Kindest regards,

    Yaddles.
    Attached Files Attached Files
    Last edited by yaddles; 07-12-2020 at 02:12 AM. Reason: solved

  2. #2
    Valued Forum Contributor
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    722

    Re: VBA Splitting DataSet across two DataSets

    Hi Yaddles,

    Try the below code ...

    Please Login or Register  to view this content.
    Last edited by nankw83; 07-10-2020 at 06:29 AM.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Registered User
    Join Date
    01-14-2014
    Location
    perth
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: VBA Splitting DataSet across two DataSets

    This is absolutely remarkable! Thank you so much nankw83!
    What a beautiful piece of code, and very elegant!

    Thank you also for the final touch with a Message Box where items are not found.

  4. #4
    Valued Forum Contributor
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    722

    Re: VBA Splitting DataSet across two DataSets

    Glad to help & thanks for the reps

+ 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. Helping with Splitting Large Dataset into Tabs
    By encampedA in forum Excel General
    Replies: 1
    Last Post: 12-14-2017, 05:52 PM
  2. Replies: 3
    Last Post: 10-20-2017, 12:40 AM
  3. Splitting dataset in to new sheets by month
    By igwtdav in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-25-2016, 12:01 PM
  4. [SOLVED] Splitting Datasets to new TABs by column title MACRO
    By ad9051 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 08-01-2012, 03:24 AM
  5. [SOLVED] Splitting datasets by their titles into multiple sheets
    By ad9051 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-15-2012, 09:00 AM
  6. Copying a dataset multiple times - and selecting titles for this dataset
    By alocke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2012, 10:15 PM
  7. Splitting title into cells for datasets
    By ad9051 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 06-02-2011, 08:12 AM

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