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.

extracting records from a list by typing one criterium
 

Why not just use AutoFilter???
--
HTH...

Jim Thomlinson


"Leon" wrote:

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.

extracting records from a list by typing one criterium
 

Because I need the results to appear on separate printable sheet.



"Jim Thomlinson" wrote:

Why not just use AutoFilter???
--
HTH...

Jim Thomlinson


"Leon" wrote:

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.

extracting records from a list by typing one criterium
 

Install EasyFilter if you want to create a new sheet with the data
But when you use AutoFilter it only print the visible data ?

http://www.rondebruin.nl/easyfilter.htm

For code (and without code) see
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Leon" wrote in message ...
Because I need the results to appear on separate printable sheet.



"Jim Thomlinson" wrote:

Why not just use AutoFilter???
--
HTH...

Jim Thomlinson


"Leon" wrote:

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.