Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
joining spreadsheets together for reports and queries?
Hello:
I have a master spreadsheet. I want to search some other similar spreadsheets for a field (column) of data that is in the master spreadsheet. In other words, I want to query the other spreadsheets to see if the data within this column in the master spreadsheet is in those other spreadsheets. Is it possible to do this in Excel through joining the sheets together, similar to database table linking, or do I need to dump this data into Access instead? childofthe1980s |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
joining spreadsheets together for reports and queries?
What you are proposing is much, much, much easier to do in Access than it is
to do in Excel. Nevertheless, Excel is a powerful tool, and it will probably handle anything you throw at it. If you demand this from Excel, it will reward you by running slow, and any updates or modifications will be complex and vexing. See these links for some ideas of what can be done: http://www.freefilehosting.net/download/3g3jd http://www.freefilehosting.net/download/3g3je http://www.freefilehosting.net/download/3g3jf http://www.freefilehosting.net/download/3g3jg Again, much simpler in Access!! Regards, Ryan--- -- RyGuy "childofthe1980s" wrote: Hello: I have a master spreadsheet. I want to search some other similar spreadsheets for a field (column) of data that is in the master spreadsheet. In other words, I want to query the other spreadsheets to see if the data within this column in the master spreadsheet is in those other spreadsheets. Is it possible to do this in Excel through joining the sheets together, similar to database table linking, or do I need to dump this data into Access instead? childofthe1980s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open all Excel spreadsheets/fles before running queries | Excel Discussion (Misc queries) | |||
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
Generate Reports from Excel Using Seagate Crystal Reports PLs... H | Excel Programming | |||
Joining worksheets | Excel Worksheet Functions | |||
HOW DO I TRANSFER EXCEL SPREADSHEETS WITH QUERIES AND MACROS? | Excel Discussion (Misc queries) |