Hi everyone,

I will start out with saying I am not good with Excel. I have done a few brief projects with VBA and user forms to make inputting data simpler, but nothing to the extent of what I hope to be able to do for this task. I am a quick learner and willing to figure it out, but would like some direction on what the best way to accomplish this is before I go and learn some way that won't work!

I have a large table of information with HUGE chunks of text in some of the cells. It is a process ID number, and then 15 columns of government requirements associated. To be able to read all the text in each box, the cells would have to be enormous. I am trying to avoid killing a forest by printing this all that largely, so I had an idea and I'm not sure how to best accomplish this.

I would like to have a form that I can use the Text->contains " " filter that you can use on a table to find the process ID number. It must be in the contains format rather than the search function in the table because the ID numbers are 123-456-789, and sometimes I need to find all the processes associated with "456" or "123" and the search bar seems to only allow complete numbers. I would then like it to display the entire cell text for each requirement in the row on a page so that I can print it out for that process.

What sort of commands/forms etc should I be using to complete this task? I just need a general direction to start heading and I have no idea how best to start out. Thanks for the help!