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: 67
Default extracting records from a list by typing one criterium

I have a large excel list comprised of 14 columns from A7 to N7 and over
15000 rows or records.

I would like some help with setting up a macro that would let me retrieve
and display all the rows that have a common value in column L (that I would
enter in the macro).

The column L lists various purchase order values,I would like to enter a
value in a macro and have it display all but only the rows (records) that
have that value in their L column.

Any help will be gratefully appreciated.
 
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
Extracting records via SQL in Excel Ken Ent Excel Discussion (Misc queries) 0 May 29th 09 07:48 PM
extracting unique records [email protected] Excel Discussion (Misc queries) 1 September 6th 07 07:55 AM
Extracting selected records from longer list Heidi Excel Discussion (Misc queries) 3 November 8th 06 05:51 PM
Extracting the Duplicate Records Santhosh Excel Discussion (Misc queries) 1 April 25th 06 02:16 PM
Extracting records from an excel list Leon Excel Programming 6 January 20th 06 08:55 PM


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