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!!
Bookmarks