Need macro to copy rows between two defined values

Good morning!

I am extremely novice with visual basic and macros, but my boss would like me to figure out a macro for sorting our budget information. Every week, we get an updated list of project budgets, so the rows to copy and paste over always vary. My job is to find the 17 projects relevant to our department and copy and paste the information into a new document. This is an example of how the first few columns look:

excel.jpg

I want to run a macro that will find each major project number I'm looking for in column B (corresponding to a number 2 in column A) and copying that row and the rows below it until reaching the next major project number. I'm not sure if that makes sense...

For example, I would want to find E1007557, select that row and all rows below it until reaching HE310204.

Is there a way to do this?

Thank you!

Here's one example.

Please Login or Register  to view this content.