Copy entire row based on a criteria - using macro

[scambug]

step: 1. search a criteria in a "sheet1" column "B" [input bow or textbox in a form]
2. copy entire row matches the step 1 until
3. meet a criteria in colum "A"
4. paste in another sheet

is it possible to have different criteria in step 1.


Thanks.

[DGagnon]

could you please provide a sample data set, and desired output?

[scambug]

My Steps:

1. Enter "Text"
2. Find in Column B [Text.Criteria], if found copy.entire row until column "A" = Text"B"
3. paste in sheet2 nxt epmty cell column "A"
4. Loop [finding Text.Criteria] if not found - End


Hi here's my datasheet.

Thanks.

[DGagnon]

where do you want the user to input the 'Text' in step 1?

[scambug]

in a userform with a textbox

[DGagnon]

Take a look at the attached and let me know what you think

[jim2012]

Maybe because it's Friday and my brain is not working, but I need the same kind of Macro in an Excel sheet. I have down loaded the sample done.xls but ican't seem to get it working! What should my criteria be in the Search box?

[DGagnon]

the search box should contain entries from column B

[jim2012]

Column B being the 8 digit numbers? I still get no results in a message box every time.

[DGagnon]

sorry friday brain... try this

[jim2012]

Very Cool, Thanks

[scambug]

thanks. but, what if 1 textbox and a button only. searchable data is in column B,
after search it copies all rows until it end in a specific criteria in column A.
the specific criteria in column A is fixed.

[jonson86]

Sorry for asking this only now.
I downloaded the sampledone2. The search option can only search for 1 row of data but how about other data matches the criteria?

[arlu1201]

jonson86,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.