LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
pgc pgc is offline
external usenet poster
 
Posts: 11
Default getting rows out of a data base

hi i have a data base looking something like this
Name Training topics training needed training completed
Paul Hilti Gun Yes NO
Paul Paslode Yes Yes
Steve Hilti Gun Yes NO
Steve Paslode Yes NO
on a seperate worksheet i have this
List box containing all names Training topics Training completed
Steve


I want the "training topics" column and "training completed" column to
show the rows in the data base based on which name i pick from the list
box please help
Ive tried Index / Match but i only get the first row ie Hilti and there
are more than two items in the "Training needs" column
IM realy struggling
Thanks

 
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
How can I convert many rows of hyperlinks to BASE links? EnduroGal Excel Worksheet Functions 2 June 11th 09 11:03 PM
Merging rows base on value in other column Real Excel Discussion (Misc queries) 2 February 17th 08 07:52 PM
update a Pivot Table with new data added to the base data Graham Y Excel Discussion (Misc queries) 1 March 19th 07 02:12 PM
how do I print data in a spreadsheet data base to a mailing lable. Kevin Jamieson Excel Discussion (Misc queries) 0 March 15th 05 10:57 PM
how do I print data in a spreadsheet data base to a mailing lable. Database Excel Discussion (Misc queries) 0 March 15th 05 10:57 PM


All times are GMT +1. The time now is 01:07 PM.

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

About Us

"It's about Microsoft Excel"