Hi all, I have two Sheets in workbook. One sheet name is "Search" and
Other sheet name is "Data". In sheet "Data" I have data like (see
below)

A B C D---- columns
555360 XX1 12 XXZ4
555360 XX2 13 XDX5
555360 XX3 14 TYU4
555360 XX4 15 GHJ4
523600 GH5 16 ERT6
523600 GH6 17 XSE8
523600 GH7 18 FDS2
589632 ZR2 19 SDR9
589632 ZR3 20 HYU1
589632 ZR4 21 SEW1

In sheet "Search" I want macro on a button that when I put any number
of column A cells of sheet "Data" in Sheets("Search").Range("A1") then
by clicking the button macro should look that number in column A of
sheet "Data" and copy rows from column A to column D (not EntireRow)
of that number to sheet "Search" in Range("A6") to down. For exampe
if i put number "523600" in Range("A1") of sheet "Search" then when i
click button macro should look this number in column A of sheet "Data"
and copy rows from column A to D in sheet "Search" in Range("A6") to
down. The result will be somthing like this (see below)

A B C D---- columns
523600 GH5 16 ERT6
523600 GH6 17 XSE8
523600 GH7 18 FDS2

I hope I was able to explain my question. Can any friend can help