+ Reply to Thread
Results 1 to 4 of 4

Building Maintenance Excel VBA Database

  1. #1
    Registered User
    Join Date
    03-01-2017
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    2

    Building Maintenance Excel VBA Database

    Hi, is there anyone that has a ready to go Spreadsheet that can be used for a Building Maintenance database, primarily for Preventative Maintenance, planning and scheduling. This is for a reasonably large estate (12 buildings) with a variety of equipment such as Water, HVAC, Kitchen Equip, Fire systems, etc etc.

    Any help appreciated.

    Scott

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Building Maintenance Excel VBA Database

    https://www.template.net/business/sc...dule-template/

    http://www.myexceltemplates.org/temp...celtmp135.html

    http://www.montgomeryschoolsmd.org/u.../SampleBMP.pdf

    https://www.vertex42.com/ExcelTempla...rder-form.html

  3. #3
    Registered User
    Join Date
    03-01-2017
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    2

    Re: Building Maintenance Excel VBA Database

    Hi Thanks but not really what I'm looking for.

    Something like the link from Youtube - https://www.youtube.com/watch?v=7jkAx8DxJxo&t=329s

    Scott.

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Building Maintenance Excel VBA Database

    a ready to go Spreadsheet
    There isn't a thing like that because every situation is different.
    The least you can do is provide a sample file with the proper layout of your sheet like columns to be used, Headers etc...
    Then make a list of what you want to be able to do with that list.
    Based on that we can gradually start to build your workbook.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Building a searchable database in Excel
    By AndrewCalum in forum Excel General
    Replies: 3
    Last Post: 10-11-2016, 04:52 AM
  2. Help building a database
    By marcospaterson in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-11-2011, 08:38 AM
  3. Using excel like a database: building a query
    By vwDavid in forum Excel General
    Replies: 12
    Last Post: 03-10-2011, 08:45 PM
  4. building database
    By chris1432 in forum Excel General
    Replies: 2
    Last Post: 11-29-2006, 06:04 PM
  5. [SOLVED] Building a zip code database
    By Rob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2005, 01:40 PM
  6. Database maintenance and Database Administration?
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 10:05 PM
  7. [SOLVED] Does anyone have a building maintenance spreadsheet?
    By curlyque in forum Excel General
    Replies: 1
    Last Post: 07-23-2005, 01:05 PM

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