Hi All, Can you please help me about this, we are having two excel workbooks, what we do is take the specific row value a, filter it into another workbook , after filtering we have to identify text matching if text match copy specific row value not entire row, can you please help me. HP PL Suffix w/out Option Comments PH Number PH Description Manufacturer Quantity AN AV Add CTO to the description 1.00223E+17 CTO Notebooks INK 1 AN AV Add CTO to the description 1.00234E+16 CTO NOTEBOOKS <100 INKA 2 this is the example file after we filter the values for 1st and 2nd col i filtered AN and AV , after filtering if PH Description column contains "<100" in the text copy manufacturer column only not all rows, like that i am having so many columns , i searched it, but i didn't get the code , help me

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

How to copy specific cells and paste it into another workbook after filtering

Thread starter satya12
Start date Oct 25, 2021

satya12

Board Regular

Oct 25, 2021

Hi All,

Can you please help me about this,
we are having two excel workbooks, what we do is take the specific row value a, filter it into another workbook , after filtering we have to identify text matching if text match copy specific row value not entire row, can you please help me.

HP PL	Suffix w/out Option	Comments	PH Number	PH Description	Manufacturer	Quantity
AN	AV	Add CTO to the description	1.00223E+17	CTO Notebooks	INK	1
AN	AV	Add CTO to the description	1.00234E+16	CTO NOTEBOOKS <100	INKA	2

this is the example file after we filter the values for 1st and 2nd col i filtered AN and AV , after filtering if PH Description column contains "<100" in the text copy manufacturer column only not all rows, like that i am having so many columns , i searched it, but i didn't get the code , help me