Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() On its way. Thanks a bunch. Bernie Deitrick wrote: Frank, If you want to use Excel as a database, then enter your data into a database: one sheet of one workbook, with all the information that you need, and all the fields by which you you want to isolate data. (Excel isn't a relational database, but you can use multiple databases if the information isn't well related, like one for personal data like addresses, and another for your actual data) Then you can use data filters to show / extract the information that you want. Forget about using multiple workbooks - they just make things harder. HTH, Bernie MS Excel MVP Hello. I need to be able to access data from Jan. '04 into the future from a [quoted text clipped - 21 lines] Thanks, -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200508/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) |