Searching Column and returning specific rows to UserForm

Hi,

Are you sure you really need to put all these rows of data in a userform box? It would be more usual (and much much simpler) to filter the relevant rows in the database itself. Either filtering the data in place or extracting the filtered rows to a new range.

Originally Posted by battdan1

I'm trying to make it more user accessible where they don't have to flip through all the different sheets. Cause I have a database for 3 seperate project types. I have a main page and I made a button to show all projects and I think, (correct me if I'm wrong) other than filtering on the sheet, a userform would be the easiest way for the user to view all the corresponding projects...

I beg to differ. You'll see more of the records if you choose to filter the selections to a blank sheet rather than try and display them in a Userform box. Freeze the column headers so that they're not lost when someone scrolls down.

Hi

First name your database, say 'data'

Then in the sheet to which you want to copy the filtered records add a row of column labels and name this range say 'data_out'
Create a two cell criteria range with the column label of the 'Y' column in one cell and immediately underneath it enter the value 'Y'. Name this range say 'crit'.

Now the macro code to extract the records is simply

Please Login or Register  to view this content.