View Full Version : Filtering A Worksheet
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
04-01-2007, 03:22 AM
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
Thank You.
Ive attached a sample document and the results I would like displayed are shown on sheet 2.
Again Thank you
Maz
lucas
04-01-2007, 08:02 AM
what string did you theoretically search for to get the results on sheet 2?
lucas
04-01-2007, 08:03 AM
or is it the result of multiple theoretical searches?
The string I used was "ab" to get the results on "sheet 2".
Bob Phillips
04-01-2007, 08:52 AM
.
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
04-01-2007, 09:42 AM
.
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!:clap:
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
04-01-2007, 12:11 PM
Is this what you mean?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.