Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-03-2008, 03:42 AM
Novice
 
Join Date: Oct 2008
Posts: 1
inferno is on a distinguished road
Default Excel or Access ?

hello
i have created an excel sheet containing different construction materials with their physical propreties and i m trying to create something that allow me in another sheet to easily find and select some materials from the databse to use them for calculations..
i ll try to explain more ..i want a cellule where i can type some letters and it will shortlist for me the potential materials that contains the letters i typed..and when i choose the spedific materials, microsoft office should get the other fileds corresponding to this material and insert them in specific cellules to perform calculations...
maybe like the list of countries in all windows and online applications.... when u type a letter only the coutries starting with this letter will appear...
i was trying the lookup and reference functions in excel .. but couldn t find what i want.. so what should i do ??
it is right to do this in excel ? or should i use access ?
thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM
Can Access access folders & sub-folders and dig out data? nrg Office 4 06-20-2005 11:09 PM
Delete excel files by code in Access Barry Richardson Office 0 06-13-2005 06:26 AM
MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM


All times are GMT -7. The time now is 01:04 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft