+ Reply to Thread
Results 1 to 2 of 2

Summarize data from different sheets in the last sheet

  1. #1
    Registered User
    Join Date
    03-25-2008
    Posts
    1

    Summarize data from different sheets in the last sheet

    Hello Everybody,
    this is my first post so I don't really know how it works...

    Anyways, I have this question:
    I have one file on Excel with different sheets named for each month, let's say, each with different data (i.e. number of hours, price per hour, etc. and the total at the end)
    I would like to have a summary of some data of each sheet on the first sheet (or final sheet, it's the same)
    like for example:
    Name of sheet: Total number of hours: Total Price:
    January: 32 100€
    February, etc. etc.

    HOW DO I DO THAT???
    Can you please help me?

    THANKS!!!

    Matteo

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    macro

    HI
    assuming the data you want to pull is in F8 & G8, Paste the following codes in the macro window ( Alt F11)

    Please Login or Register  to view this content.
    Run the macro.
    Ravi

+ 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