+ Reply to Thread
Results 1 to 13 of 13

Create sheets named by header and populate them with sorted data

  1. 02-15-2013, 04:28 PM #1
    salaso69
    salaso69 is offline
    Registered User
    Join Date
    04-14-2011
    Location
    Buford, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Create sheets named by header and populate them with sorted data

    Create sheets named by header in sheet "Table" and populate them with data from sheet "Points" sorting by column E and corresponding sheet name from "Table" sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-15-2013, 09:07 PM #2
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: Create sheets named by header and populate them with sorted data

    With autofilter header I came to this solution.
    Attached Files Attached Files
    Harry.
    Reply With QuoteRegister To Reply
  3. 02-15-2013, 09:28 PM #3
    salaso69
    salaso69 is offline
    Registered User
    Join Date
    04-14-2011
    Location
    Buford, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Create sheets named by header and populate them with sorted data

    Wow, works! Thank you so much. What can I change in the code to get everything stating with raw 1


    Thanks again,

    Sasa
    Reply With QuoteRegister To Reply
  4. 02-15-2013, 09:35 PM #4
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: Create sheets named by header and populate them with sorted data

    Add the red text in the code.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-15-2013, 09:40 PM #5
    salaso69
    salaso69 is offline
    Registered User
    Join Date
    04-14-2011
    Location
    Buford, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Create sheets named by header and populate them with sorted data

    Ok, but now in table TOPO I get doubled row one. Also is it possible to get data sorted by column A?

    Thanks a lot
    Reply With QuoteRegister To Reply
  6. 02-15-2013, 09:47 PM #6
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: Create sheets named by header and populate them with sorted data

    In sheet "Points" there are 4 rows been added by mistake, remove them.
    Reply With QuoteRegister To Reply
  7. 02-15-2013, 09:53 PM #7
    salaso69
    salaso69 is offline
    Registered User
    Join Date
    04-14-2011
    Location
    Buford, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Create sheets named by header and populate them with sorted data

    Thanks again
    Reply With QuoteRegister To Reply
  8. 02-16-2013, 02:20 PM #8
    salaso69
    salaso69 is offline
    Registered User
    Join Date
    04-14-2011
    Location
    Buford, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Create sheets named by header and populate them with sorted data

    Hello Harry,
    What would be change in the code if I add one more column in sheet "Table"

    Thank you,
    Sasa
    Reply With QuoteRegister To Reply
  9. 02-16-2013, 02:31 PM #9
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: Create sheets named by header and populate them with sorted data

    Hello Sasa,

    Can you upload the file ?

    Or is this enough.
    Please Login or Register  to view this content.
    Last edited by HSV; 02-16-2013 at 02:44 PM.
    Reply With QuoteRegister To Reply
  10. 02-16-2013, 02:50 PM #10
    salaso69
    salaso69 is offline
    Registered User
    Join Date
    04-14-2011
    Location
    Buford, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Create sheets named by header and populate them with sorted data

    Thanks for fast respond. I test it and it works well. The only thing is that in sheet "Points" you have filters on but I can live with that.

    Looks like you wrote a completely new code?
    Reply With QuoteRegister To Reply
  11. 02-16-2013, 02:56 PM #11
    salaso69
    salaso69 is offline
    Registered User
    Join Date
    04-14-2011
    Location
    Buford, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Create sheets named by header and populate them with sorted data

    Hmm, after second look I noticed that row 2 is copied in every sheet.
    Reply With QuoteRegister To Reply
  12. 02-16-2013, 02:59 PM #12
    HSV
    HSV is offline
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    860

    Re: Create sheets named by header and populate them with sorted data

    For the filters,
    Add the red text.
    Please Login or Register  to view this content.
    You can also use the other code.
    Change the 3 into a 4.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  13. 02-16-2013, 03:47 PM #13
    salaso69
    salaso69 is offline
    Registered User
    Join Date
    04-14-2011
    Location
    Buford, USA
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Create sheets named by header and populate them with sorted data

    My deepest appreciation
    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)

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