Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a function or functions to query Excel worksheets like you would a
database? Maybe using SQL? Here's the issue I'm having - I need to design a scorecard type of spreadsheet with a separate sheet for each employee evaluated. Rather than have each worksheet contain 3+ queries, I would prefer to link directly to the Access data tables I'm pulling the info from (into a "Data" worksheet) and then query the "Data" worksheet from the other worksheets. Is this sounding crazy? Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Querying data | Excel Discussion (Misc queries) | |||
Querying Internal Data | Excel Discussion (Misc queries) | |||
Querying a range within Excel | Excel Worksheet Functions | |||
QUERYING ACCESS | Excel Discussion (Misc queries) | |||
Querying Data from Access | Excel Discussion (Misc queries) |