hi

i need a macro or button to display the row data into another sheet or in to another file like text pad...

for example

here is the row

Button abcdef, 1234, date, data1,data2

above is the single row but there might be many rows in excel sheet

what i need is when i click on button it just show the corresponding row data in different sheet or text pad file....

if hyperlink solve the problem than plz tell me that as well.......