Look for an number in a column

Honestly you're requirement went over my head.

for example
I mean all the values that contain 41 in that column


i mean i need 3 sections where the 41 appear and  2 more down

what i mean after i get 41 in column B all  the ocurrence of 41   next to so populte the sheet only with that ocurrence

I need the fist 12 rows where  the 41 appear and  24 down rows

Try the attached workbook. To test it, select a number in column "B" and then click the 'Report' button. Do several tests of course but in one of them please select cell B4. That's a special case because there's no data above it. Is that the way you want it to look? In other words is Range(A1:I1) on the sheet supposed to be there? Normally, according to your examples, it shouldn't be there.
29017760.xlsm

Subodh Tiwari (Neeraj)  thanks for you help !!
let me know if you need more information please

Did you try my workbook?

Martin looks like working Great !!
but i need make some last minute change
add some columns needed !!

can you please adjust !! it
review-with-adjustment-column.xlsm

What columns did you add? What is different between your new workbook and mine?

Martin is you see the adjustment sheet i create with the correct columns count !

Ok, try the attached. Did you ever select cell B4 and then click the Report button?
29017760a.xlsm

Martin !!

here is the the file with the add columns
review-with-adjustment-column__ON__.xlsx

Did you try the workbook I just posted?

yes sorry my good friend !!

i did not select the cell b4   and not hit report

is because i add some coulmns to the original but need the same function

is ok ?

Adrianna, you aren't answering my questions.

Did you try the workbook I just posted? [In post ID: 42103067]

And about B4, what I'm asking you do do is

1. Select cell B4
2. Click the Report button
3. Tell me if the report is exactly what you want

Martin Yes !! I hit the selection in b4  and hit report and is working great!!

So is there anything more you need before you close this question?

Martin I'm stuck
is not working after i add the column i tell you

Attach your workbook that isn't working.

here with the coulmns i need
review-with-adjustment-column__ON__.xlsx

That has no code in it. Please attach the workbook that led you to say that it isn't working.

but martin taht what i need !!

This is the file you send me but i can't see the code master
29017760.xlsm

That's not the latest. I sent you an update (version "a")  back here. In any case I attached another update, version "b".
29017760b.xlsm

yes you rigth this is the last  one im testing now!

29017760b.xlsm s the most recent version.

i test this file last one
i just copy and paste the data

select the cell i need and hit report buttom

but isnot working nothing happens in the report

i test it    29017760b.xlsm

Did you follow these steps?

1. Open 29017760b.xlsm
2. Make sure you were on Sheet1
3. Pasted in new data
4. Selected a number in column "B"
5. Clicked the button

If yes, then I need to see what the workbook looks like after you did step 3.

BTW in the "b" version there's not a lot of data in columns J, K and L, but if you select 41.5 and click the Report button you'll find the JJ, KK, LL data I added to Sheet1.

ok Martin  I follow ! the steps from
ID: 42103345

this what i get !!

from ID: 42103353
I see what  you say  martin and is rigth !

but when i paste the data i need  nothings happens!!

Attach the workbook that's in the picture you posted.

heres is Martin !
review-data-adjustment.xlsm

Is working Great !!!

Grea Expert !!
thanks for you big patiente with me !!!
My Good friend !!

You're welcome.