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
Bookmarks