LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default make a box with... or other solution

I have a view sheet1 "View" that gives me de data of sheet2 "List" :
LIST=
"A: number
B: name
C:adress
D: contact
F:issue......"

by inserting in sheet1 cel Q3 "1" it gives me the data of "B1, C1, D1,..."
=Vlookup(Q3;list!A9:AS2008;2;FALSE)
i want to view by the name, and not by the number.
so, going to "list" sheet, putting a shearch box (always visible) to shearch
EX: "paul", it will give me the number for me to put in sheet "view" in "Q3"
by pressing a button link " VIEW DETAILS " ( go to sheet "view cel Q3").

ps: that´s a very big list whit almost 60 columns each one with diferent data

solutions are welcome.
i dont know if I'm clear
thank's in advance


Paulo Alex - Santa Maria - Azores Island


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for a solution CA Linda Excel Worksheet Functions 1 July 7th 09 05:31 PM
solution wants shoyeb2045 Excel Discussion (Misc queries) 4 August 14th 08 08:34 PM
Web Solution StephenBexcel Excel Discussion (Misc queries) 0 May 13th 08 06:30 PM
Need a pop up solution! [email protected] Excel Discussion (Misc queries) 4 June 21st 07 11:13 PM
Is There A Solution.......? Thyagaraj Excel Programming 3 August 8th 06 03:59 PM


All times are GMT +1. The time now is 05:43 PM.

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

About Us

"It's about Microsoft Excel"