retrieve row data

**ualtaf** · 10-26-2010, 09:12 AM

i have one sheet

serial no. data1 data2 data3 data4
1 asd asd asd asdf
2 sef *** dfgdgf asdf
3 dasdf dsfd sadfs sdfsdf
4 dsfds dsfsad sdfsa ssf
5 gfdg dgfsd sdgfdsa were

when i click on serial it shows me the row data on other sheet

for example
if i click on 2

serial no. data1 data2 data3 data4
2 sef dfgdgf asdf

it show row2 data on other sheet

i also attached the file with this thread

Solved with this

Originally Posted by JBeaucaire

Like so:

Please Login or Register  to view this content.

OK, now it's your turn. If your "requirements" change again you take a stab at changing the code given to match your new requirement and then ask us about your code and your attempts, OK?

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

http://www.excelforum.com/excel-new-...-in-excel.html

Please don't post the same question multiple times, stick with one thread.

Since this post got the sample file, I'll respond here, but the answer is the same. VLOOKUP() does this. I put this in C5 and copied down/across as needed.

=IF($B5 = "", "", VLOOKUP($B5, Sheet1!$B:$F, COLUMN(B1), 0))

**Simon Lloyd** · 10-26-2010, 09:43 AM

We need more info than that, how do you want it displaying? is sheet 2 empty? if not where should it display?, should the data in sheet 2 change if another cell is clicked?, what if a cell with no data is chosen?

Why not attach a sample workbook?

Microsoft Office Help - Excel VBA Programming

**Marcol** · 10-26-2010, 09:49 AM

Is this what you mean?

In the worksheet module for Sheet 1

Please Login or Register  to view this content.

Click on a serial number to see the result.

Simon
The OP did attach a workbook it has dissapeared and I cannot attach the file in this post.

See the .jpg attached, taken from IE recovery

[EDIT]
Success attaching file on the third attempt

**scottylad2** · 10-26-2010, 01:13 PM

maybe, i've named your data as lookup_table

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

Originally Posted by Simon Lloyd

We need more info than that, how do you want it displaying? is sheet 2 empty? if not where should it display?, should the data in sheet 2 change if another cell is clicked?, what if a cell with no data is chosen?

Why not attach a sample workbook?

Microsoft Office Help - Excel VBA Programming

i want yo display in the column form. yes the sheet 2 is empty, yes the data should change if another cell is clicked. every cell must have a data that is sure
i attached the sample workbook

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

Originally Posted by JBeaucaire

http://www.excelforum.com/excel-new-...-in-excel.html

Please don't post the same question multiple times, stick with one thread.

Since this post got the sample file, I'll respond here, but the answer is the same. VLOOKUP() does this. I put this in C5 and copied down/across as needed.

=IF($B5 = "", "", VLOOKUP($B5, Sheet1!$B:$F, COLUMN(B1), 0))

thanx JBeaucaire
it is little bit making sense for me , can u help me how i can use vlookup for click
for example if i click on serial number cell it automatically shows that row data on other sheet.. can u plz help me more on this?

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

I've already shown how to do it without a click. Your sample sheet listed a requirement that I showed how to solve. You'll have to demonstrate how you mean if not that.

**ualtaf** · 10-27-2010, 02:50 AM

Originally Posted by JBeaucaire

I've already shown how to do it without a click. Your sample sheet listed a requirement that I showed how to solve. You'll have to demonstrate how you mean if not that.

here i attached my exact requirement file
on sheet1 when i cllick on "2" it shows the corresponding record or row of "2" on sheet2, as mentioned in the test file
this is my exact requirement.. please help me regarding this....

**JBeaucaire** · 10-27-2010, 03:16 AM

1) Right-click on the Sheet1 tab and select View Code

2) Paste in this event macro:

Please Login or Register  to view this content.

3) Close the editor and save your workbook as a macro-enabled .xlsm file

4) Now anytime you double-click on a cell in column B, the row will be transferred to sheet2 in the next empty row.

**JBeaucaire** · 10-29-2010, 09:57 AM

Is this the correct solution or not? It appears you're trying to start new threads for the same question. If this is not the correct solution, respond here in this thread.

**ualtaf** · 10-30-2010, 01:39 AM

no this is not the correct solution i was searching for

becaz that transfer the row in next empty row
the solution i want is to update the same row and only one row will be shown in sheet2 which is clicked in sheet1
another thing it is not automatically shown the sheet2 on click and it is working on double click not on single.......

**JBeaucaire** · 10-30-2010, 04:30 AM

Try this instead.

Please Login or Register  to view this content.

**ualtaf** · 10-30-2010, 07:41 AM

this problem is partially solved

the remaining part is that this do not directly open the sheet2.....

if i want to show the data according to my requirement in sheet2, than?
for example this show the data in row form

but what if i want to show this in column form or in two columns as shown in attachment test file

**martindwilson** · 10-30-2010, 08:20 AM

see attached uses index match
hmm i just noticed this was not a new thread and i never read any of the above! so this may be a complete waste of space

**JBeaucaire** · 10-30-2010, 11:21 AM

Like so:

Please Login or Register  to view this content.

OK, now it's your turn. If your "requirements" change again you take a stab at changing the code given to match your new requirement and then ask us about your code and your attempts, OK?

**ualtaf** · 11-01-2010, 01:21 AM

Originally Posted by martindwilson

see attached uses index match
hmm i just noticed this was not a new thread and i never read any of the above! so this may be a complete waste of space

index doing the same thing what i have done with vlookup.....

please tell me, can we use vlookup and hyperlink together for the purpose i explained above???
please guide me

**JBeaucaire** · 11-01-2010, 01:27 AM

Not to click on Sheet1 and have things appear on sheet2, that requires VBA.

You could use VLOOKUP on sheet2 if you used a selection criteria of some kind in C7...like a drop down. With a manual selection in C7, the rest of the cells could do a vlookup, though INDEX/MATCH is a better choice.

**ualtaf** · 11-01-2010, 01:37 AM

Originally Posted by JBeaucaire

Like so:

Please Login or Register  to view this content.

OK, now it's your turn. If your "requirements" change again you take a stab at changing the code given to match your new requirement and then ask us about your code and your attempts, OK?

Solved My problem

Thank You , thank You very much....how can i make this post solved

**JBeaucaire** · 11-01-2010, 01:48 AM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

**martindwilson** · 11-01-2010, 03:43 AM

grief that was hard, sorry i muddied the waters lol

**ualtaf** · 11-01-2010, 08:22 AM

Originally Posted by martindwilson

grief that was hard, sorry i muddied the waters lol

its ok martin no need to say sorry

actually that code solved my problem through VBA

retrieve row data

LinkBack

Thread Tools

Rate This Thread

Display

retrieve row data

Re: retrieve row data

Re: Row Data Extraction

Re: Row Data Extraction

Re: retrieve row data

Re: Row Data Extraction

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Re: retrieve row data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions