Creating new application in Excel

[Stan Denman]

I am an attorney and I am able to access my case data through a government site. I can download a excel spreadsheet with a row for each of my cases, and columns for various items of data. One very important use of these spreadsheets for me is to be able to see status changes, or new cases added to the spreadsheet. But it is tedious to go through the spreadsheet line by line. Also, the reports often have lots of "deadwood" - cases that have been closed but are still showing on the report.

I was thinking 2 kinds of functionality sure would be great: (i) the new spreadsheet could have new entries in a different color and (ii) a sort/filter function that take out the closed cases, or filter for a given judge, etc.

Any ideas to help me get started?

[VBA FTW]

For (ii), if you have dedicated column headers, you can apply a filter and custom sort without any VBA code.

For (i), how do you currently know when there is a new case/status change? You said you currently go row by row, but is there an identifier that tells you it's a new case? Or are you comparing the new list to the old list, line by line?

Also, you may want to edit the title of your post to be more specific with regards to exactly what you're trying to accomplish. You'll get more views

[Stan Denman]

Just comparing the new list to the old list.

[VBA FTW]

Can you provide a couple sample workbooks with a few rows of sample data in them? I need to see what the data you're working with looks like to determine how to identify new cases/status changes.

BTW...I'm leaving work now so I may or may not be back until after Labor Day, nothing personal, just need a little time away from coding