View original (French)

Creating a spreadsheet with multiple sheets

ni-ni-27 Posted messages 19 Status Member -  
ni-ni-27 Posted messages 19 Status Member -
Hello everyone,

I would like to create a cemetery register (I am the town clerk),
I have inserted the plan of my cemetery on a sheet that I renamed "Plan", each concession has an assigned number, I created a link so that when I click on the location number it takes me to the sheet that concerns only that location. So far so good, I'm managing.

Then I created another sheet that I renamed "Register", on this sheet I write the first and last name and other information regarding the buyer. The duration of the purchase, etc.

My problem is as follows:
A location is valid for 100 years, and I would like my software to create a sheet for each year of reminders if that is feasible.

I also want that on the sheet concerning the location, when the location is taken again by someone else, I can keep the name of the previous person. To keep a history!

I hope I have been clear enough!

Thank you all!

6 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello Ni-ni-27

    A simple idea in the folder

    http://www.cjoint.com/c/GCclafEENyx

    --
    It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from their mistakes.
    2
    1. ni-ni-27 Posted messages 19 Status Member
       
      Thank you very much!!! It's awesome!!! :)
      0
  2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello

    It's doable on Excel, provided you have complete and accurate information;

    Since you're already selecting a location, you might not need as many sheets as there are locations. One sheet could cover all locations and their history, and you could filter (or select) by the location number; then, optionally, you could manage the location's progress through a form (userform), print it...

    In the "register" sheet, it would be interesting for each buyer to have a unique identifier (multiple Martins...) in the first column.

    Depending on the number of buyers and the number of lines in the history, you could create either one workbook or two.

    But, there’s a lot of work to do! ...

    Michel
    1
    1. ni-ni-27 Posted messages 19 Status Member
       
      Thank you for your advice!!
      0
  3. ButteDuLac Posted messages 534 Status Member 41
     
    Hello,

    I would like to help you, but I'm not sure I understand.

    I wonder, at first glance, if your tool wouldn't be more convenient in a database, rather than managing it in Excel!?

    Furthermore, if I understand correctly, you want a sheet to be created for each location (by the way, is a concession a location, or is a concession "a sale for a location"?), for each year for 100 years? So each location would have 100 sheets... and moreover, since the location can be sold for a predetermined number of years (if I understand correctly), then resold at that term or put back on sale, in that X number of years, there would be a need for another 100 new sheets for the same location?

    If I understand correctly, if you have 10 locations, that would give you a minimum of 1000 sheets in a workbook? You risk getting a very large file... but maybe I didn't understand correctly?
    0
    1. ni-ni-27 Posted messages 19 Status Member
       
      Hello.

      A concession is a site sale.

      I want one sheet per site and that this sheet is updated with each concession sale.
      0
  4. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello

    To complete buttedulac (hello); how many plots are there in the cemetery,

    indeed, with a database....
    if possible 
    Attach the spreadsheet without confidential data on "mon-partage.fr" 
    and right-click to paste the shortcut in your message

    Looking forward to your reply

    --
    Michel
    0
    1. ni-ni-27 Posted messages 19 Status Member
       
      I would say more than 100 locations.
      When you say database, are you talking about Access?
      0
    2. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320 > ni-ni-27 Posted messages 19 Status Member
       
      The software question will come later
      for now, I only see people with recent concessions, so we would need a list of people since 1916-17!

      Whether it's through Access or Excel, it will be dense VBA and you will need to be able to modify and develop everything (80% of the application life completed..)

      If necessary, we can create a database in Access format without having Access, but it's lengthy and difficult to accomplish...
      0
    3. ni-ni-27 Posted messages 19 Status Member
       
      Je suis ici pour traduire. Veuillez me donner le texte à traduire.
      0
    4. ni-ni-27 Posted messages 19 Status Member
       
      I have concessions that are over a hundred years old, and this database would allow me to follow up to recover the locations.
      However, it is on paper, and I need to digitize everything.

      I wanted to know if my IT project was feasible before entering everything.
      0
    5. castours > ni-ni-27 Posted messages 19 Status Member
       
      hello
      Why not inquire in large municipalities about how their cemeteries are managed?
      In my opinion, there must be ready-made software available.
      Also worth checking online.
      Some companies offer free services.
      0
  6. castours
     
    Moreover, some locations are family vaults, so one sheet for each deceased and one sheet for the owner of the concession.
    0
  7. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    I also live in a small municipality and anything that reduces local taxes is well received by the residents... Currently, my town hall is making calls regarding abandoned vaults (concession periods that have long expired)

    You should at least provide the structure with 2 or 3 lines filled with dummy data from the 2 sheets you created so that we can try to help you
    Reminder of my request 
    Attach the workbook without confidential data on "mon-partage.fr"
    and right-click-paste the shortcut in your message

    Looking forward to it

    --
    Michel
    0