+ Reply to Thread
Results 1 to 4 of 4

Summary sheet from recent entries in other sheets

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Summary sheet from recent entries in other sheets

    Hi. I'm new to the forum so apologies if I've put this in the wrong place.

    I have an excel document that contains around 15-20 sheets, which each store the disk space levels of individual servers. These sheets are filled in on a daily basis, and include data such as the date, time, and the disk space level. What I am looking to do is take the most recent entry from each sheet and use them on a summary sheet, which will then show the most recent entry for each of the servers. From here I have some code ready that will enable me to automatically email the necessary person to inform them if the disk space is low.

    What I need to know is how do I pull the most recent entry from each sheet onto one summary sheet? I need the summary sheet to be able to automatically update and recognise the new entries as I put them in each day.

    Thanks,

    Andrew.

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Summary sheet from recent entries in other sheets

    What is the structure of ur data in detailed sheet i.e. which column will help excel to determine that this record is the recent on.

  3. #3
    Registered User
    Join Date
    01-28-2010
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Summary sheet from recent entries in other sheets

    I want excel to use column A which contains the date, in DD/MM/YYYY format. So that it can just look in that column find the most recent date and use that and the corresponding row of data.

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

    Re: Summary sheet from recent entries in other sheets

    Hi
    Insert a sheet called Summary and paste the following codes in the macro window ( Alt F11).
    Please Login or Register  to view this content.
    run the macro. it lists sheet names in col A and pastes the most recent data of that sheet from B to AA.
    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