Results 1 to 5 of 5

Taking cell values from Dashboard, and based on a value load in one of two sheets

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2011
    Location
    Your House
    MS-Off Ver
    Excel 2003
    Posts
    6

    Taking cell values from Dashboard, and based on a value load in one of two sheets

    Greetings-
    I am happy to say I am new here, and I have looked around, and I am very happy with the meaning of this forum.

    I would like to take a chance to say that I appreciate any advice given with my post.

    So here is what I would like to do. As you can see I have attached a sample workbook of the data I am looking to populate in the two work sheets.

    As you can see the Dashboard pulls from all of the other tabs in the workbook. I would like to take the data that populates in the Dashboard, and filter that so to speak. I know I could do a filter manually, but I am hoping to have this done automatically.

    If you look in the Spreadsheet, under the tabs '>=10' and '<=10', respectfully I would like to take the values in Column B from the sheet Dashboard if the value is greater than 10, to automatically list the whole row in the >=10 sheet. If the cell value in Column B in the sheet Dashboard is less than 10, I would like to have the whole row populated in the <=10 sheet.

    I am not sure if I put this in clear words, if you require more clarification please let me know

    Again Thanks in Advance!!
    Attached Files Attached Files
    Last edited by califire; 01-10-2011 at 10:18 PM. Reason: I left some words out...

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