+ Reply to Thread
Results 1 to 2 of 2

Trying to sort out a small excel spreadsheet for a Cat Protection Charity

  1. #1
    Registered User
    Join Date
    09-14-2015
    Location
    ipswich, england
    MS-Off Ver
    2010
    Posts
    31

    Trying to sort out a small excel spreadsheet for a Cat Protection Charity

    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
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Trying to sort out a small excel spreadsheet for a Cat Protection Charity

    Unless there's a reason why she needs individual sheets for each owner and each vet, I would just have a single sheets for owners and a single sheet for vets. Otherwise, you are going to have so many different tabs in this workbook. Also, I am not exactly sure what you are asking for? Are your macros not working properly?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 04-22-2020, 08:29 AM
  2. Replies: 5
    Last Post: 01-07-2019, 11:42 PM
  3. Dictionary-like Excel spreadsheet (SMALL(IF(Index...,ROW()))
    By sampahmel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-14-2014, 10:38 AM
  4. Replies: 2
    Last Post: 01-31-2012, 05:40 PM
  5. Finding all Instances of a certain value in a small excel spreadsheet
    By CircuitAkita in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-19-2011, 01:37 AM
  6. Replies: 0
    Last Post: 03-22-2007, 07:32 PM
  7. Excel Spreadsheet Protection
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2006, 09:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1