copy and paste based on cell value / text

Hi,
any particular reason you want to do this with a macro instead of a formula?

You could simply use Vlookup

=VLOOKUP(B3,data!$B$3:$F$14,2,FALSE)

ok ive found some code which is kinda what i need

Please Login or Register  to view this content.

heres what it does:
you click the button on sheet2........an input box is shown..............you type in a number of text to search for..............it searches sheet1 colum a for a match...............if a match is found it copys the row from sheet1 to sheet2 in the next avaliable row.

heres what i need:
click the button on sheet2 (report tab)..............macro will search colum a sheet1 (data tab) for the number or text that i typed in sheet2 (report) in cell b3..............if a match i found it will copy the data to the right of the matching number onto sheet2 in the green area shown
the data copied from sheet1 will always be colums b to f but the amount of rows differs.

please see attached sheet in the first post it will be easier to see what i want from that

thanks

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I think nobody really knows what your question is.