Filtering A Worksheet

[maz]

Hi

I have been given the task to filter a whole worksheet for specified text. The user needs to be prompted to enter the text and any cells which contain the text in sheet 1 needs to be copied to sheet 2 with the corresponding cell in Column A and B.

I have tried hopelessly and feel I am at the end of my tether.:banghead:

I have tried to use auto filter and advanced filter but it doesn?t seem to work for more than one column. Also I have tried VB but I have had no luck. :dunno Can anyone help me?


Many Thanks
Maz

[Simon Lloyd]

Maz, Welcome to VBAX, your request is a little sketchy, do you want only the values from columns A & B to be copied to sheet 2? where will the text your filtering for be? how many columns?....etc, these are just a few questions that need answering, you would be better off if you posted a sample worksheet with the data you want to manipulate and on sheet 2 an example of what you would expect to see.

Remember when posting you sample worksheet make sure there is no personal or sensitive data on it!

Regards,
Simon

[maz]

Thank You.

Ive attached a sample document and the results I would like displayed are shown on sheet 2.

Again Thank you

Maz

[lucas]

what string did you theoretically search for to get the results on sheet 2?

[lucas]

or is it the result of multiple theoretical searches?

[maz]

The string I used was "ab" to get the results on "sheet 2".

[Bob Phillips]

.

[maz]

Thank You!!!!

But how do I get "Sheet 2" to only display cells from "Sheet 1" that contain "ab"?

Sorry I dont have a clue when it comes to vb!!!:dunno

[Bob Phillips]

.

[maz]

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!:clap:

[maz]

Hi

Ive tried to change the VB formula to search for specific text in sheet 1 however the results shown in sheet 2 show all cells which have that particular text even if it is located within a word for e.g If I search for only cells which contain ext it will bring results containing Text1 ex and not just cells which contain "ext" as a separate word like TEXT ext.

Could you help me?

Many thanks!!

Maz

[Bob Phillips]

Is this what you mean?

[maz]

THANK YOU!!:friends: