Quote:
Originally Posted by inreality01
Unique city is nothing more than I am looking at the "Jurisdiction" column and I'm creating a column with just unique entries. I did this so that I can then add just items for those unique cities a little easier. It is my way of breaking the problem up into multiple steps.
|
Ah ok.
Quote:
|
The reason there are multiple tabs is because each tab represents a different investigator. The person using this spreadsheet goes to each investigator and tracks which cases they are assigned...... which incident types and cities, etc.
|
What do you think about combining them and adding a field (i.e. a column) to track investigator for each record?
Quote:
|
I personally think a small Access DB would be better for doing what he is doing but this is what I have to work with at the moment.
|
No doubt. Unfortunately, few people use Access anymore and I think Microsoft is letting that tomato wither on the vine to die.