Results 1 to 5 of 5
  1. #1
    Join Date
    May 2014
    Posts
    10

    Question Unanswered: Create sheets from one sheet based on value

    Hi guys,
    i have Excel sheet with thousands rows.
    Lets say that first 400 rows in first column contain the same value (lets say A), other columns different..
    Second 400 rows have the same value in the first column (lets say B).

    Is it possible to write macro that creates two sheets, first sheet will contain first 400 rows wit value A and secon sheet will contain second 400 rows with value B?
    Could you give me an Idea how this macro should look like? i am newbie with macros

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Why do you want to do this?
    It might sound like a good idea but from experience I can tell you it becomes a bit of a maintenance nightmare!
    George
    Home | Blog

  3. #3
    Join Date
    May 2014
    Posts
    10

    Angry reason

    Quote Originally Posted by gvee View Post
    Why do you want to do this?
    It might sound like a good idea but from experience I can tell you it becomes a bit of a maintenance nightmare!
    Reason to do this is, that i am exporting data from MS Access. I have report in access which contains many data.
    For my next work i need to get tables based on values in first colmumn. It looks like this>
    Code:
    1.column    2. column    3. column
    a               20             50
    a               30             30
    a               10             60
    b              110             160
    c               210             60
    c               310             60
    and I want to get sheet that have just values in rows with a, second sheet with values in rows with b....etc
    and also i have a lot of such big reports..
    Last edited by gvee; 06-04-14 at 10:43. Reason: code blocked.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    So you could end up with 10,000 worksheets if you're not careful!

    Personally I would just put all the data in a single sheet and then use column filters to show only those I am interested in.
    George
    Home | Blog

  5. #5
    Join Date
    May 2014
    Posts
    10
    Quote Originally Posted by gvee View Post
    So you could end up with 10,000 worksheets if you're not careful!

    Personally I would just put all the data in a single sheet and then use column filters to show only those I am interested in.
    yeah man, i am thinking about it and you are right. I realized that I need to make report based on multiple tables/queries where can i get data based on value in column and then just export it...
    thanks

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
  •