Help with scroll box on a sheet

I was wondering if there is a way to insert a scroll able box on a single sheet. What I am attempting to accomplish.... I have created several sheet that will allow data input from employees. I need to find a way to make a box that contains two columns and about 40 rows. I would like the employee to be able to just scroll down the box without having to scroll down the entire sheet to enter data. I do not need to pull data from any other sheet and a text box will not work. all I want them to do is be able to scroll down and enter information in the new scroll box.

Is the user just adding more rows of data to the bottom of the table?
If so try this approach

Give the users a button at the top of the sheet that takes them automatically to the next available blank row

- add a Command Button at the top of the sheet
- right click on button and select "View Code"
- insert the code below (modified as appropriate)

This code assumes that column A determines the next row.
So if data is in column C, amend "A1048576" to "C1048576"

Please Login or Register  to view this content.