Vba to search matching texts partly or fully in a purticular column

[ROHAN999]

I have texts to search in column c

I am using data filtei by texts that contain and or method that is a tool of excel..

But can i have vba to automate this process which can give me rows of similar text matching party or fully in column c

But i have data in sheet 1 and i want to use vba in sheet 2.so that i can have result in seprate sheet.

[PCI]

To help to prepare macros, please attach a short EXCEL file giving an idea about your data value and layout

[ROHAN999]

sir

i am attaching sample sheet with results ,kindly assist me.

[anilpatni1234]

I can help but the code works for the same sheet.

You can filter data of sheet 1 on sheet 1 itself.

Would that help you?

[PCI]

What is the difference with the use of filter ?
For example :
Prepare filter for colums A to C
in header column C make selection "to "

[ROHAN999]

I can help but the code works for the same sheet.

You can filter data of sheet 1 on sheet 1 itself.

Would that help you?

No sir as the result is required in different sheet

Still you plz provide that code

I may try something else with it

[ROHAN999]

What is the difference with the use of filter ?
For example :
Prepare filter for colums A to C
in header column C make selection "to "

Sir i am using filter only with contain text search but the data remains big, after filtei i use to copy it paste it via note pad to avoid copying of mid rows then there i use them further

If i get such data directly in other sheet my job will become bit smoother

[PCI]

To avoid to prepare macro which is doing the job of the filter , I would suggest that you prepare man ually the filter and then clic on a button or something else to launch a macro to record filtered data into a new sheet.
What do you thing ?

[ROHAN999]

Please Login or Register  to view this content.

KINDLY ASSIST IN AMEDNDING THIS

[PCI]

See here what we can do
In the file attached you can play with the macro
What you have to do:
Make the selection you want with the filter
Do Control + a to launch the macro

Please Login or Register  to view this content.

[ROHAN999]

thanx alot sir

its working fine

but Criteria1:=Range("g1") give the exact sir

can i have any option to check partly matching part

for example i put as in g1


then in column 3


sentences having as will remain in filter

i mean in place of exact match , the sentences which contains the phrase remains there in filter

[PCI]

It is only a matter how you prepare the filter selection in Excel
see

[ROHAN999]

sir

i wanted to know how to change this

Please Login or Register  to view this content.

to get partly matching stings/text rather than exact match

[ROHAN999]

i want to match text which contains G1 text not exactly G1

that is what my threat heading too sir-partly or fully

kindly assist so that it may not even remain case sensitive if possible

[PCI]

It seems you want to prepare the filter using macro ...!
See how the "Hom" selection is working with next code and file attached

Please Login or Register  to view this content.

[ROHAN999]

that is correct sir

but how will i change search string every time

that i why i was using G1 cell reference so that whatever will be written in cell G1 will be the search string

rest the code works fine

[PCI]

See next code

Please Login or Register  to view this content.

[ROHAN999]

this is working fine sir

THANX ALOT

[PCI]

whatever i will write in cell g1 that will become search string

Yes this what is doing the last macro sent.
Up to you to choose what sort of search you want to do: Certainly the last one