+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Pulling data from Sheet x to Sheet y based on formatting

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    omaha, nebraska
    MS-Off Ver
    Excel 2007
    Posts
    22

    Pulling data from Sheet x to Sheet y based on formatting

    Hello, all. This will be my first post and hopefully quite a few people benefit from my question. Here we go:

    Using Microsoft Excel 2007 on Vista

    I have created a spreadsheet for my boss that tracks due dates for tests. I have 13 sheets in this excel document, one for each month and then an "overdue" tab.


    I have formatted each month's entries to turn green when done, yellow when 20 days from being due, orange for 10 days from being due, and red for the day the test is due and will stay red once past due.

    Here's my issue... I am having to constantly update the "overdue" sheet and would like it to automatically pull the formatted red rows from all sheets to the overdue sheet.

    is there a way to make the "Overdue" sheet update itself this way?

    **EDIT** - i posted a reply under this post with a copy of my workbook (with some personnel data taken out, of course)

    Thanks!

    ~Blizz
    Last edited by blizz; 10-22-2010 at 12:10 PM.

  2. #2
    Registered User
    Join Date
    10-20-2010
    Location
    omaha, nebraska
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Pulling data from Sheet x to Sheet y based on formatting

    here's a sample book.example.xlsx

  3. #3
    Registered User
    Join Date
    10-20-2010
    Location
    omaha, nebraska
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Pulling data from Sheet x to Sheet y based on formatting

    Bump... Anyone able to help on this one? Here, let me re-word the question:


    Say something is overdue in tab 3....
    how do i get my workbook to automatically populate tab 1 with these overdue items?

    that being said...
    how do i get the overdue items on the overdue tab (tab 1) to remove themselves when i update tab 3 saying that the item has been taken care of (is no longer overdue)??

    any help would be GREATLY appreciated... kind of on a time crunch here.

    ~Blizz

    PS: a sample workbook is attached in the post above this one.

+ 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