How to add dynamic table for data entry that also has a scroll bar

Hi Everyone,

I've been working on a document for my job that is, in short, going to be used for estimating jobs. This will require the user to choose resource types (engineering, installation, etc..) as well as number of hours for each resource. There is also an equipment tab that is for entering what equipment is required and how much it costs.

In the "Installation" tab, I have 3 separate tables for 3 separate phases of installation, each requiring entering the resource types and number of hours. I have these tables kept fairly small so it's easier on the eyes, but some odd jobs may require many many resources, so I want to find a way to be able to add rows to these tables, while keeping my formatting, formulas and data validation in place. I can't have a button to insert rows for all 3 tables separately, since that would mess with the formatting a whack of other issues. I've deleted a lot from the attached workbook just to keep things simple, but the true document is filled with dozens of tabs and lots more data beneath these tables that I want to be easily accessible! I would simply have a different tab for each phase of installation, but there are already too many tabs, and I'm trying to simplify this for each department that needs to use it.

Ideal Solution If Possible: I want to be able to have a dynamic and scrollable table for each installation phase (ie:, for Installation Phase 1, that's D10:G17), so that if someone needed to have say, 40 resources for the Phase 1 installation table, they could simply scroll down and add more instead of having to insert more rows to that table, thus adding more rows to the entire worksheet. Can I have that range be scrollable? Can I add rows to that scrollable area so it's not scrollable right away until it's needed?

I just really need this table to keep the data validation in column D, while also keeping the formulas in columns F & G for any new rows that may be added.

Any help would be GREATLY appreciated, as I have been spending a ton of time online and watching Youtube videos trying to figure out how to do this, but to no avail. Hoping it's possible! Or, if you have a better alternative, I'm all ears

Originally Posted by JohnTopley

One option is to have a multi-page Userform - one per phase for example - which will allow both entry of the data and ability display in a scrollable list. Your tables can be a fixed size (range) in your workbook.

Thanks for the suggestion! Could that user form be 3 separate static boxes, or can I only use it to enter data and then transfer that data back into my worksheet?

Originally Posted by JohnTopley

You can use such a form to enter/modify/delete data and display it i.e all of the appropriate table. Data entry can then transfer to your worksheet.

Attached is demo of a userform: does this address ( in principle) your requirement?

This is VERY cool! I think I can definitely find some very useful applications for this, but I don't think it'll work for what I'm intending to achieve in this instance. Basically, I want the experience to be as easy as possible for the user, while still being able to easily see what resources and # of work days they have selected for each installation phase. The way I currently have it set up is what I want it to look like for the user, but I want them to be able to add rows in each phase easily so they are limited to adding only 8 resources. I hope that makes sense. I know it seems easy enough to manually insert a blank row, but believe me, the people I work with wouldn't even be able to figure that out with a full tutorial haha