A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Help with show info on one row in Excel 2007



 
 
Thread Tools Display Modes
  #1  
Old August 17th 12, 10:06 AM
hendrikbez hendrikbez is offline
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 1
Default Help with show info on one row in Excel 2007

I want to know how I can get help with this.


I have about 12 columns and more than 400 rows of information.

My second row is empty and this is were I want to do the following

I know how to make a drop-down list for the firs column. but now I want to when I click on the list and get an name, it
must also show all the info of this name in the rest of the columns.

If I click on a name in my drop-down list, on SAPX02 (there are two of SAPX02 (ROWS 265 and 266)) so if I click on row 265(SAPX02) it
must give me that row265 info on row 2, and if I click on row266 (SAPX02) it must show row 266 info on row 2 for me.
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
import dynamic info from web Excel 2007 hawaiiham2000 Excel Discussion (Misc queries) 0 March 22nd 10 03:05 PM
Will I lose info when I un-install excel 2007 pttimer Excel Discussion (Misc queries) 1 April 1st 09 12:31 AM
How to get the ribbon to show - Excel 2007 Foxwiz Excel Discussion (Misc queries) 2 March 13th 08 01:22 AM
How do I show info only in cells used Kev Excel Discussion (Misc queries) 1 December 17th 05 11:03 AM
Excel validation drop-down: how show codes with descriptive info? gborn Excel Discussion (Misc queries) 1 June 23rd 05 11:09 PM


All times are GMT +1. The time now is 11:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 ExcelBanter.
The comments are property of their posters.