Search for string help

[tschroder]

I am trying to get this macro to search through column A to find all entries with a certain name (user input) and then copying and pasting each matching row to a different sheet in the work book. Here is what I have so far:

Please Login or Register  to view this content.

This seems to do what I am intending, however, it only returns the very first match and does not search throughout the entire column. The sheet with the data is named "Table" and the sheet I am copying too is "Summary." Any help would be much appreciated!

Here is an example of the data I am using:
Tyler Barto 5 8. 7.50 .50 .50 7. 6.50 0 1326 0 222 1296. 521 204.00 80.
Jake Parker 6 5. 1.70 .50 .50 4. .70 0 264 0 0 274. 137 377. 196. 61.
Rob Carlton 7 5. 4. .50 .50 4. 3. 0 885 0 248 859.3 0 290 271. 89.

[stnkynts]

Please Login or Register  to view this content.

[xladept]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


I also rewrote your code:

Please Login or Register  to view this content.

[pjwhitfield]

how about a different method. Instead of cycling through records, copying and pasting rows, simply filter the data to the desired results and paste the lot into the other sheet.

Please Login or Register  to view this content.

[tschroder]

xladept- received a invalid qualifier on this line:

Please Login or Register  to view this content.

PJ- I am presenting this data to some who are not proficient in Excel so I want it as user
friendly as possible (click a couple of buttons, type a name and results). Also data is added to this work book daily so I think this is a much easier way to manage it. Your code worked perfectly thank you!

[xladept]

Try:

Please Login or Register  to view this content.

and if that doesn't work maybe you could:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[xladept]

Oops! wrong thread