| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting records via SQL in Excel | Excel Discussion (Misc queries) | |||
| extracting unique records | Excel Discussion (Misc queries) | |||
| Extracting selected records from longer list | Excel Discussion (Misc queries) | |||
| Extracting the Duplicate Records | Excel Discussion (Misc queries) | |||
| Extracting records from an excel list | Excel Programming | |||
Linear Mode
