Results 1 to 3 of 3

Create new worksheet for each set of unique values

Threaded View

popfan Create new worksheet for each... 01-16-2012, 01:34 PM
arlu1201 Re: Create new worksheet for... 01-16-2012, 01:59 PM
popfan Re: Create new worksheet for... 01-16-2012, 02:35 PM
  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Missouri, USA
    MS-Off Ver
    Excel 2007
    Posts
    36

    Create new worksheet for each set of unique values

    I am looking to try to create a macro that will be able to create a new worksheet with naming schema and copy and paste all rows of a table based on the unique value in column A. I would like the naming schema to be based on that unique value with a table. Attached is a worksheet that will create the new worksheets(run Regionwks on the unique worksheet) , but I cannot figure out how to copy and paste those unique rows in the Main worksheet to the new worksheet.
    Attached Files Attached Files
    Last edited by popfan; 01-16-2012 at 02:36 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1