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.
Bookmarks