Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Relational Techniques... there's got to be a better way
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 Database Formatting | Excel Discussion (Misc queries) | |||
Addressing Techniques | Excel Discussion (Misc queries) | |||
Advanced Copy/Paste Techniques? | Excel Worksheet Functions | |||
Box-Jenkins techniques & Time Series | Excel Worksheet Functions | |||
what exactly are relational operators in Excel? All math symbol? | Excel Worksheet Functions |