monthly consolidation in separate worksheet

Discussion in 'Microsoft Excel Worksheet Functions' started by sorab, Aug 3, 2011.

  1. sorab

    sorab Guest

    we have 5 employers each having their own salary worksheets, which has
    rows with the different incomes and deductions for each, and columns
    for each month. now we have filled up for the past three months. We
    would like to have a single separate worksheet called MAINSHEET (or
    any other name) in same workbook, from where we can choose to show
    for any particular month of our choice the following:
    In rows - all employees names and in columns each of their incomes and
    deductions as per their individual page alongside their names for that
    particular month.
    Then we can print out this consolidated sheet, and for next month just
    enter the month and get the same details again, for each requested
    month..
    I am not good in vb, but any ideas would be helpful
    thanks
     
    sorab, Aug 3, 2011
    #1
    1. Advertisements

  2. sorab

    Gord Guest

    Copy all sheets' data into one sheet then use filtering to pick which
    month and data to show.

    For VBA see Ron de Bruin's site.

    http://www.rondebruin.nl/summary.htm


    Gord Dibben Microsoft Excel MVP

    On Wed, 3 Aug 2011 02:38:57 -0700 (PDT), sorab
    <> wrote:

    >we have 5 employers each having their own salary worksheets, which has
    >rows with the different incomes and deductions for each, and columns
    >for each month. now we have filled up for the past three months. We
    >would like to have a single separate worksheet called MAINSHEET (or
    >any other name) in same workbook, from where we can choose to show
    >for any particular month of our choice the following:
    >In rows - all employees names and in columns each of their incomes and
    >deductions as per their individual page alongside their names for that
    >particular month.
    >Then we can print out this consolidated sheet, and for next month just
    >enter the month and get the same details again, for each requested
    >month..
    >I am not good in vb, but any ideas would be helpful
    >thanks
     
    Gord, Aug 3, 2011
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Worksheet consolidation help

    Guest, Mar 3, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    144
    Guest
    Mar 3, 2006
  2. Guest

    How can I count the number of ranges in a worksheet consolidation

    Guest, Mar 7, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    131
    Guest
    Mar 7, 2007
  3. Guest

    consolidation of data from other worksheet

    Guest, Apr 19, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    135
    Guest
    Apr 19, 2007
  4. Wondering

    Consolidation Worksheet Data Sequence.

    Wondering, Sep 25, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    161
    Wondering
    Sep 25, 2007
  5. Satya Nanduri

    Consolidation of Data from more than one worksheet file

    Satya Nanduri, Nov 23, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    228
    Ashish Mathur
    Nov 25, 2009
Loading...

Share This Page