View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Leon Leon is offline
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.