Results 1 to 2 of 2

Split up existing worksheet into worksheets via macros

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-28-2010
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    105

    Split up existing worksheet into worksheets via macros

    Hi I have attached a sample workbook.
    I would like to create a Macros which can take the existing worksheet and split it up into worksheets for each merged cell entry in column A. Basically you can see that the first entry, runs from row 1 to row 44, I would like to cut all those and paste that to a new worksheet and name it after the entry which in this case is "land erfeim", and do this for all subsequent merged cells.. reason being is i have more data in the subsequent columns for each unique row.
    Attached Files Attached Files

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