Hi there !
I plan to make a tool for ornithologist to help them :
- know what birds can be spotted at a given time of year
- tell when to spot a given bird
I've an excel file made like this :
...............................jan.......fev.......march........apr.......may ....
Sparrow.................0...........0............0...............0...........1 ....
Robin......................1...........2...........3................2...........1 ....
Mocking bird..........0...........0...........2.................0..........1 ....
Numbers tell how frequent the birds are to be seen a given month :
0 : bird absent
1 : few birds
2 : common
3 : many !
the list is about 200 birds and I want
- only the spotable birds being displayed when time is chosen
ex :
month : march
Robins : many !
Mocking Bird : common
- only months when a given bird is then spotable
ex :
I want to spot Sparrows
Come in May !
Created list from sorting the ecxel file could be long so user may need to be able to scroll down the screen.
any ideas how to achieve that ?
thanks !
Laurent