Create data form

Is the main reason you are refraining from doing this in Access the cost of the licenses for the end user? You only need one full license. That license develops the applications. The end users can use free, runtime-only licenses that allow them to use the applications but not change them (which is what you want anyway).

To develop the full application in Excel is possible, but requires a lot of programming to do what you get "for free" in a database.

If you do get a taker for this project, that person is probably going to want a sample workbook with data and a mocked up picture, if nothing else, for what you have in mind for the form.

- Filling out a form and appending a new record - relatively easy
- Selecting a key field from a drop down list and deleting it from the data table - relatively easy.
- Listing all the records - moderately difficult.
- Putting the code behind each created field on a list of records to detect if a field has been changed - difficult.

The option to putting the code behind each created field is to assume that every record has been changed whether it actually was or not, deleting the entire contents of the table and running though each field to re-create every record. This is an inefficient process.

All of this will take hours of programming vs. minutes of programming in a database.

Adding records or deleting them is relatively easy. Also, you could pull up a single record for editing. The difficult part would be getting a "continuous form" like you do in Access.

So it would work like this: Pull up a form that looks like it holds a single record. Using a drop-down list, select the record you want. Click a button to add, edit or delete the record. This is a moderate amount of work and actually would be a fun challenge, but if you can live with it we can do it. What I can't deliver is to list out all the records at once.

The data would have to have a key field such as a Project ID.

I just had a thought mid-keystorke. Let me think about this some more. Depending on how the data are organized. I could give you a pivot table and slicers. Use the slicers to select the records you want and then click a button to edit or delete them.

Attach a sample workbook with a dozen or so sample records.