LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
SKKB
 
Posts: n/a
Default Filtering data from one worksheet based on another

I need to display the rows in spreadsheet A based on whether a numerical
value in a particular column has the same value in a corresponding column of
spreadsheet B for example:

Spreadhseet A Spreadsheet B
1 2
3 3
5 6
6 7
7 8

The resulting filtered display should be

3
6
7

With all other data in the associated rows.

Thanks


 
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
eliminate data entered to a worksheet that copies to another work. flaguilar Excel Worksheet Functions 2 March 14th 05 05:20 PM
Merging data from an excel worksheet into an excel template pkasler Excel Worksheet Functions 1 March 13th 05 04:36 AM
Formatting a worksheet for data entry DV in Texas Excel Worksheet Functions 2 March 6th 05 07:48 PM
How do I automatically hide columns in a worksheet based on a cell value? dkhedkar Excel Worksheet Functions 1 March 5th 05 12:20 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 08:16 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"