+ Reply to Thread
Results 1 to 2 of 2

Merging Problem

Hybrid View

  1. #1
    Registered User
    Join Date
    09-14-2010
    Location
    Noida,India
    MS-Off Ver
    Excel 2003
    Posts
    1

    Merging Problem

    I have multiple sheets (not fixed) in my workbook, Now I want to create a summary sheet.
    All the input sheets have same formatting with multiple rows and 3 columns data (min, max and avg). The summary sheet will also contain multiple rows and 3 column data(same as the input sheets).
    Suppose E5 on all the available sheet contain min data. Then summary sheet's E5 should have formula something like

    E5 "=MIN(Sheet1!E5,Sheet2!E5,Sheet3!E5)" and subsequent

    F5 =MAX(Sheet1!F5,Sheet2!F5,Sheet3!F5)
    G5 =MAX(Sheet1!G5,Sheet2!G5,Sheet3!G5)

    if Input sheets are 3.

    Since Input sheets are not fixed so I don't want to create a formula, I need a macro. Kindly suggest how it can accomplished.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Merging Problem

    You can pop a couple of blank worksheets in your workbook and call them First and Last. If you then use a formula such as =MAX(First:Last!E5) it will include any worksheets you place between them on your tab strip.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

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