+ Reply to Thread
Results 1 to 5 of 5

Combine identical macros of different worksheets into one.

  1. #1
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Combine identical macros of different worksheets into one.

    The only difference between the two macros is that they belong to different worksheets. I just want these two macros to be converted into a single macro. Also have attached a sheet if necessary to understand.

    This one belongs to sheet MC4
    Please Login or Register  to view this content.
    This one belongs to sheet MC5
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Sarangsood; 10-17-2013 at 06:27 AM.

  2. #2
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Re: Convert two identical macros into one single macro.

    Also i have got 10 such identical macros of different sheets in my original workbook. So will it be possible if i could merge all of them together?

  3. #3
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Re: Combine identical macros of different worksheets into one.

    Also i have got 10 such identical macros of different sheets in my original workbook. So will it be possible if i could merge all of them together?
    As in one macro to rule them all

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

    Re: Combine identical macros of different worksheets into one.

    I have put the two codes in one in module 1.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    05-18-2011
    Location
    Delhi , India
    MS-Off Ver
    Excel 2007
    Posts
    171

    Re: Combine identical macros of different worksheets into one.

    thank you

+ 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. Macro or VBA to convert multi-row data into a single row
    By jz789 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2013, 10:15 AM
  2. Identical worksheets, identical data, different arrangements
    By Hooty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2012, 05:02 PM
  3. Replies: 4
    Last Post: 11-03-2012, 12:02 PM
  4. Using macro to convert single level BOM to Multi Level BOM
    By andrew_chong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2006, 04:57 PM
  5. [SOLVED] identical macros run fast and slow
    By markwattwood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2005, 04:15 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