Copy rows from worksheets that contain specific text into a summary worksheet.

[ChocksterNo1]

Hi

I have 1 workbook that contains multiple worksheets. In each worksheet, in Column C, there will be be different text. I need to copy the row in each ws that has the word PENDING and paste the row into a summary worksheet. The number of rows that has the word PENDING could vary from 0 to 1000. This workbook is updated regularly.

Hoping, someone could help me out with this problem.

Thanks

Chock

[stnkynts]

Try:

Please Login or Register  to view this content.