Find a certain text from entire sheets in the workbook and copy the row. Plus copy the sheet name ad

[siopao017]

Hi Guys,

I really need your help on this one. I have a work book with so many sheets, but I only need the row based on the word "Total WIP". I need to copy the row where that text appears plus i need to copy the sheet name after the copied data and all of the information will be pasted on the new sheet name "Data".

As you see the data you will notice that rows where the "Total WIP" word repeats. I need those info but I want to copy it in only one sheet. I don't want to over write what's copied on the first sheet, so after the first data the second data will be under the first data so on and so forth. This problem goes through entire sheet in the workbook i'm working on.

Random Column Random Column
$1,246.00 Total WIP


$945.00 Total WIP


$3,060.00 Total WIP

$1,040.00 Total WIP


$4,320.00 Total WIP

$2,278.00 Total WIP

$4,104.00 Total WIP

$2,664.00 Total WIP

$4,410.09 Total WIP



Thanks in advance.

 

[siopao017]

If there's anyone who can help me with this, that would be really helpful. I'm new to VBA and can't code enough to build like this one.