Results 1 to 14 of 14

Create Sheets based on values in range

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Create Sheets based on values in range

    Hello everyone
    I have a sheet with data
    In range("M13:M " & LastRow) there are values ..
    I need to create a sheet for each value and copy the data related to that value to its related sheet
    Here's an attachment
    The expected results :
    Sheets to be created : JD - MD1 - MD2 - MK
    and in every sheet the data related to it according to the value in column M

    Thanks advanced
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create sheets based on range
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2015, 05:31 AM
  2. Replies: 0
    Last Post: 11-04-2013, 01:48 PM
  3. VBA Macro to Create Sheets Based on Column of Values
    By chicagoland8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 11:39 AM
  4. unique values (range) to create new sheets
    By Hitchhiker_Nürnberg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2011, 02:56 PM
  5. Create/Name sheets based upon values
    By Miraun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2009, 12:11 PM

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