Copy rows with matching first column value into another sheet

Hi all,

I am confounded by this one, even though I have spent most of the day searching for an answer! In Sheet4("CareNavigator") are many columns of data, but the data I strive to search for is in Column A. There may be 2000 rows to search through, and where a row matches the value of a UserForm textfield, I'd like that entire row (and any others also matching) copied to Sheet9("Reporting").

So for instance Column A in Sheet4 has 27 rows where the AUID is 1234567. That's the value I select in my textbox, and then following that the 27 rows are copied into Sheet9 ready to run my report.
As the saying goes, it's "doing my head in"

Any help greatly appreciated!

Pete

Is it possible to attach a sample workbook?

Here's an example of the spreadsheet with the userform. The CmdClick has no code behind it - yet!!!

Hi,

Check out the file attached..

Thanks NeedForExcel,

That runs perfectly
BUT... I had to edit one line to read Sheets("CARENAVIGATOR").Select, then it worked!

cheers and thank you ever so much for being so speedy!
Pete

Not sure why you needed to edit one line to read Sheets("CARENAVIGATOR").Select

Any ways, glad I could help..

Hi Pete,

Here's one way to do it:

Please Login or Register  to view this content.

You could also give some thought to populating the TxtAUID text box with the unique entries from Col. A of Sheet4 to eliminate any data entry error (though I have included a routine for this in the above).

Regards,

Robert

Thanks Robert,

I shall put that version into the solutions list that I have!

regards
Pete