LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Compare spreadsheets & then extract data

I have an excel spreadsheet; the first column is name of a company with other
information of the company in the rest of the columns. The spreadsheet has
multiple entries for a particular company. How do I prompt the user for the
company name in the second spreadsheet so that I can provide the user only
the appropriate data from the first (larger) spreadsheet?
 
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
How to compare and extract data in two columns SK Excel Discussion (Misc queries) 1 August 7th 08 04:29 AM
how do I compare 2 spreadsheets of data? TEENA Excel Worksheet Functions 1 November 15th 07 12:26 AM
Extract & compare data on different worksheets DavidH[_2_] Excel Discussion (Misc queries) 1 May 11th 07 07:08 AM
How do I compare data between spreadsheets? Bryan Excel Worksheet Functions 1 July 18th 05 04:05 PM
Compare data on two spreadsheets. dcjames Excel Discussion (Misc queries) 3 April 9th 05 12:49 AM


All times are GMT +1. The time now is 09:04 AM.

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"