need solution to extract the data of row in excel

**ualtaf** · 10-26-2010, 05:24 AM

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.......

**JBeaucaire** · 10-26-2010, 09:06 AM

I don't use VBA for simple one-to-one row data retrieval like this. There are basic worksheet functions designed for this.

VLOOKUP()
LOOKUP()
INDEX/MATCH()

**ualtaf** · 10-27-2010, 01:17 AM

thanx for your help

can u give me a small example???

**Paul** · 10-27-2010, 01:21 AM

Cross-posted at: http://www.mrexcel.com/forum/showthr...12#post2489912

**JBeaucaire** · 10-27-2010, 02:24 AM

I use INDEX/MATCH for this, but you can also use VLOOKUP() or LOOKUP() based on some other restrictions about the layout of the table you're searching. INDEX/MATCH has none of those restrictions.

Here's some sample sheets showing what I think you're looking to do.
INDEX/MATCH Examples

INDEX/MATCH explanation
http://www.excelforum.com/excel-gene...ame-row.html#3