Results 1 to 2 of 2

Thread: Split data from data model into separate sheets based on a clolumn value

  1. #1
    Seeker kkalomiris's Avatar
    Join Date
    Dec 2016
    Posts
    5
    Articles
    0
    Excel Version
    365

    Split data from data model into separate sheets based on a clolumn value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,
    does anyone knows has to split data from an excel data model into separate sheets based on a column value?
    I have found many solution, mainly based on VBA, but all have as a input a sheet and not data model's data.
    Please keep in mind also, that my data are more than 6 mil rows, so I cannot upload them into a sheet, due to limitation of 1.4 mil rows

    Thanks a lot

  2. #2
    Acolyte alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    95
    Articles
    0
    Excel Version
    2019
    Upload a sample of your data with a before and after scenario mocked up so that we can supply you with a workable solution. Without seeing your data, there is no way of knowing how you want your data split.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •