Creating a spreadsheet for data entry/ manipulation

[merlin2k1]

This is probably easy, but it has been so long since I have had to use any programming that I am being stumped (have no reference materials readily handy)

I have a simple spreadsheet/ table that holds data concerning work to be done at certain locations.

I have created a userform that allows the user to enter all the information needed to populate the spreadsheet.

The next two steps that i need to get done are as follows:

1) I need a form that takes input from the user (usually a location name) and upon hitting a command button the form should go and get all the records that have that location name and show all the work that needs to be done at that location.
***I have created the userform for this and just need to program the "get info" button to autofilter the information and present it to the user (either on the form or imported to a word file)

2) This form will be identical to the previous in that it will take a location name from a user and display a list of work to be done. But in this case, the user will be able to check off when the work will be completed and when the form is closed the program will update the spreadhseet by deleting the rows that were checked by the user.

I know what I want to get done but for some reason i am stuck on how to get started...

I would appreciate any ideas on what would be the mest way to tackle this problem. I think that it should be easy, but I am not seeing it :-(

Sorry for the length and thank you for you help in advance

 

[merlin2k1]

if I forgot to mention, I need to do this in VBA. I need to put all to code into the forms so that the end user doesnt have to "think" all that much.

The end users are people that are not computer literate and have no desire to become so!!!

 

[merlin2k1]

Thanks for anyone that might have been looking, but I figured out what I needed to do.

I was looking at it as too complex and realizied after sleeping on it that it was easier than I had been trying to design