Copy multiple rows from multiple sheets if certain cell is x [Closed]


I have a purchase order document in excel that can have from 30 sheets to 500. In cell B14 on
each sheet there is a code, if it is equal to "5010" I want rows 19 through 40 copied to a sheet called Summary. I do not want blanks.

So I need a loop where it looks at B14 in sheet 01 and if it is 5010 then rows 19 through 40 are
copied to sheet Summary then it looks at B14 in sheet 02 and repeats the process.

Can anyone help?


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!