Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relational techniques
HI all. I've got a database that I read from via MS Query; no big deal with that. However I need to relate data in tables in a manner that just isn't possible with Query. The first solution I came up with is to have individual sheets as lookup tables - flat queries - with the data I need. Then I have a primary sheet that uses VLookup to gather the data from the individual sheets. It's as if I had a RDMS and was looking stuff up in tables by a key. It works fine, except for updating. If I refresh the main sheet, the data in the other sheets doesn't automatically refresh, unless I use the timer in the properties, which sux. I've seen mention of implementing this technqiue using sheets as a data source, just like a query to an external database. Would something like this solve my refressh problem? That is, eliminating the VLookup and replacing it with some kind of sheet to sheet or worksbook to workbook connection? Is there a 'refresh hierarchy"? TIA Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relational Techniques... there's got to be a better way | New Users to Excel | |||
Regex techniques | Excel Programming | |||
Relational Database Formatting | Excel Discussion (Misc queries) | |||
Addressing Techniques | Excel Discussion (Misc queries) | |||
Relational Mapping Pattern for Excel/Relational DB | Excel Programming |