LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J-Unit
 
Posts: n/a
Default Querying 2 Excel files

I have 2 seperate excel files where I need to compare data in one with data
in the other file.

A further twist is I need to match the Forename, Surname and date of
distribution which are fields in both files.

Firstly is it possible to compare or query data in one excel file with
another excel file and if so could anyone give me an example to work to

Secondly is it possible to query multiple fields for matching records across
these 2 files again an example would be greatly appreciated if this is
possible.

I would appreciate any help on this.
 
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
Issue opening csv files in Excel Emre Yigit Excel Discussion (Misc queries) 3 March 16th 06 07:24 AM
combining data from several excel files into one file bobman Excel Discussion (Misc queries) 3 March 12th 06 08:34 AM
how to copy multiple Excel files from Outlook into Excel??? Brainless_in_Boston Excel Discussion (Misc queries) 0 February 24th 06 03:46 PM
Excel Files Acting Weird Anat Excel Discussion (Misc queries) 0 March 29th 05 03:07 AM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 06:25 PM


All times are GMT +1. The time now is 11:53 PM.

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

About Us

"It's about Microsoft Excel"