Allow users to select records, by their criteria.

[Guest]

Hi,

Heres a strange request, but I hope someone can help:

Need to be able to display change requests using USER input criteria in a form format.

User chooses environment(4 possible environments), then chooses date range(from-to), and excel will display the matching record/s.

Then the displayed records then must allow the USER to select individual records and display all information for the record.

Thanks.

 

[Dave Hawley]

Hi

Have you had a look at Excels "Auto Filters" found under "Data" on the main menu? I think they maybe well suited.

 

[rstone25]

Hi,

Thats very helpful, but is there any way of hiding the data and presenting it in a nicer format (like a form)?

Thanks

 

[Dave Hawley]

The 2 options would probably be a Data Form again found under data, or a Pivot table. The "Data Form" option would only be suited to a relatively small table.

After these 2 you would be needing a UserForm in VBA.