+ Reply to Thread
Results 1 to 2 of 2

Summary Sheet help with multiple sheets

  1. #1
    Registered User
    Join Date
    09-20-2006
    Posts
    3

    Exclamation Summary Sheet help with multiple sheets

    I have an excel workbook with multiple sheets. (Let's say that Sheet 1 is the summary sheet and sheets 2, 3 and 4 are the sheets in which data is entered)

    I want the information from sheets 2, 3, and 4 to come into the summary sheet (sheet 1) in the order that they are entered. For example, if I enter information in sheet 2 on 9/20/06 at 4:00 PM and enter information in sheet 3 on 9/21/06 at 9:00 Am, I want the info from sheet 2 to appear first on the summary sheet.

    Is there a special function that I can't figure out, or is there someone that can help me with this process?

  2. #2
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    You would have to use some sort of macro that would upon entry of information on Sheets 2-4 it would put it appropriatly on the summary sheet.

    I'm not very good with macros though...

    Hope it helps a little...
    John

+ 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