Xl

Closed
fifo - Jun 9, 2010 at 09:06 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 9, 2010 at 11:40 AM
Hello,


What if I want to find a cell that starts with a specific character. Example I want to look for all cells with a word or string or characters starting with the letter "U". Then return this information or automatically copy it into another workbook....??? Its hurtng my Brain. Thanks

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 9, 2010 at 11:40 AM
You can try filter and choose begins with.

As for copying, have you tried macro recorder

start excel macro recorder
apply filter
copy the visible row
paste on other sheet
stop the recorder

this should give you the macro
0