Find specific cell, copy row from several tabs and paste in summary sheet

Please use Code tags for your code []

Hey! Thanks that was very quick

just copied your code and pasted it over my old and ran it

worked just about fine, only in each tab in columns F:M (number entries), N (an equation), O:U (number entries), V (an equation), W:Y (number entries), Z&AA (equations)
it only collected ones. I would like it to collect whatever the cells says...which will be a number between 1-10. Perhaps it would be simpler to have the equations in the summarysheet and only collect F:M, O:U and W:Y?

Really new at this, so what du you mean with wrap the code witht he code tag?? []

So so greatful for your response!!

Reg code tag, see my post.

Can you post the workbook with your desired result?

So you use the code tags.
On your first post hit edit and put [*CODE] and the begining of the code and [*/CODE] at the end of the code witouth the *

Example of desired result.xlsm

here I try to describe!

tried that on my old code...doesn't work, I guess there's alot of things wrong with that? so trying to sort out jindon's code

thanks

helnil
You put the [*CODE] tags here in the forum not in your code in the workbook.... Edit your post. So it looks like jindon
post
like this:

Please Login or Register  to view this content.

got ya!

You have 20201 in AE2,

You must be searching 20101

Do you want to add to the bottom?

It is clearing according to your original code.

Please Login or Register  to view this content.

What do you want to do when new number entered?

I just want to look at and compare the the numbers that comes up for the specific work package I search for...e.i remove them when I run the next one.

What I will then do is to insert the 4 different averages in a trend-diagram. But I haven't figured out how I would like that to look like. So that's a later problem or I might do it manually...

So I just want to collect the row of numbers and text belonging to a specific work package, and have a look at the data.

Then the code should do.

The code will pick up the number entered in AE2 from Issue # sheets and place in the right position as you click on the button.

The code works excellt, thanks for the help!