Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

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 ?
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel or Access ? 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
Excel or Access ? 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
Excel or Access ? MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd. is not affiliated with Microsoft