LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 122
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open all Excel spreadsheets/fles before running queries Fredrik Excel Discussion (Misc queries) 0 April 30th 10 11:01 AM
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report Prashanthi Setting up and Configuration of Excel 0 February 18th 08 03:02 PM
Generate Reports from Excel Using Seagate Crystal Reports PLs... H Chinx21 Excel Programming 0 May 5th 07 02:23 AM
Joining worksheets Khurum Excel Worksheet Functions 3 April 16th 07 03:32 PM
HOW DO I TRANSFER EXCEL SPREADSHEETS WITH QUERIES AND MACROS? Peachtree Help Excel Discussion (Misc queries) 1 March 20th 05 06:45 AM


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"