+ Reply to Thread
Results 1 to 7 of 7

VBA / Macro help needed to create separate sheets from Master sheet by year

  1. #1
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Question VBA / Macro help needed to create separate sheets from Master sheet by year

    Folks,

    I have a workbook with a "Master" sheet, I need a macro to create seperates sheets for each year (Based on Column "F" cell values of Master sheet). I have attached the excel file of what I'm trying to accomplish.

    Thanks in advance for your expertise!

    Joshi
    Attached Files Attached Files
    Cheers,

    Joshi
    Being with a winner makes you a winner

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA / Macro help needed to create separate sheets from Master sheet by year

    Joshi,
    You have lots of merged cells, so it is difficult to know where is the last column. Is it column J or NL?

  3. #3
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA / Macro help needed to create separate sheets from Master sheet by year

    Hi AB33,
    Thanks for your reply.

    Please note that the Last column : In the "Master" sheet it is BCJ, for new sheets NL.

    Thanks in advance.

    Joshi

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA / Macro help needed to create separate sheets from Master sheet by year

    Sorry!
    Even if I unmerged the cells, the cursor go slowly if I move to the right. I suspect there is something wrong with the data. Could you please unmerge the cells and re-attach and see what it looks like.

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA / Macro help needed to create separate sheets from Master sheet by year

    What happens to letters of columns after J? They disappeared until column CTS

  6. #6
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: VBA / Macro help needed to create separate sheets from Master sheet by year

    Hi AB33,

    I have unmerged the cells and re-attached the workbook. Please note that I have adjusted the column width to 0.10 from "K" to CTR to set-up to single page, because of that only the cursor went slowly (Please see the re-attached workbook for better look).

    Thanks in advance.

    Joshi
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA / Macro help needed to create separate sheets from Master sheet by year

    Joshi,
    I really have hard time coding because you have merged cells all over the place. The code will not let paste data unless I unmerge the cells. You will get an error if you have merged cells in either sheets, i.e. source or new tabs.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. extract rows from master sheet into separate sheets
    By nikki3973 in forum Excel General
    Replies: 2
    Last Post: 07-26-2013, 12:55 PM
  2. Create a Master Sheet from several individual sheets
    By srrosenzweig in forum Excel General
    Replies: 5
    Last Post: 05-21-2013, 04:27 PM
  3. create sheets' data from master sheet
    By ShadowRider in forum Excel General
    Replies: 9
    Last Post: 10-17-2010, 03:23 AM
  4. Master sheet into separate sheets then delete macro.
    By motown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-03-2009, 02:20 PM
  5. Macro to create new sheets from master data sheet
    By adsigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 09:21 AM

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