hi all
I hope someone can help. A friend of mine who works saving cats and neutering feral cats is now being supported by a national UK cat charity and has found that he is being overcome by the amount of enquiries and cats she is now saving and wants to keep track of everything on a spreadsheet. I have constructed a spreadsheet but have got only so far as my small amount of knowledge takes me.
The spreadsheet has a summary sheet which details totals, an owner sheet for each new cat owner enquiry and a VET Entry sheet to keep check of those vet practices that have agreed top provide low cost surgery.
The owner sheet is where the owners details are entered and then a button when pressed creates a new sheet, names it and then transfers the owners details to that sheet an d so on for each new owner.
The VET sheet is where the VET's details are entered and then a button when pressed creates a new sheet, names it and then transfers the VET's details to that sheet and so on for each new veterinary practice.
I have gone down the route of having two separate population sheets because my friend is completely illiterate when using spreadsheets and I am trying to make it fool proof! The attached spreadsheet gioves you some idea of what I mean. The file does contain three examples owner and vet sheets only as an example.
Hope someone can help, thank you.
Paul
Bookmarks