Results 1 to 5 of 5

Macro: Split worksheet into tabs.

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2010
    Location
    WI
    MS-Off Ver
    Excel 2007
    Posts
    77

    Macro: Split worksheet into tabs.

    Hello once again, I am tasked with splitting apart a report into different tabs so that those tabs can be saved as a .pdf on different pages. Then I need to split those.

    I will try to be a clear as possible to make this easy for myself .
    -Sorting by Unit number(value) in column B.
    -Every one has the same header.
    -Each tab has the name of the unit number.

    I will add an example of the report I need to break into these tabs.

    Basically this macro will search column B for a value then take all rows with the same value in column B and paste it into a new tab with a set header.
    Attached Files Attached Files
    Last edited by TWent; 11-17-2010 at 03:48 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