Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel help!
What statement would I use if I want to search a exce data base and find all
rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd |
#2
|
|||
|
|||
good question huh?
-- Todd "Toddmend" wrote: What statement would I use if I want to search a exce data base and find all rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd |
#3
|
|||
|
|||
I'd apply Data|Filter|Autofilter
Use a custom filter of equals X (or contains X--depending on what you meant). And then copy those visible rows and paste to the new worksheet. Toddmend wrote: What statement would I use if I want to search a exce data base and find all rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd -- Dave Peterson |
#4
|
|||
|
|||
But I want this to be an ongoing database. I would like it to be a formula
where I can enter something inew n the main database, and then if it has "X" in that colum, it will automatically be brought to the "X" file (which is a seperate file) -- Todd "Dave Peterson" wrote: I'd apply Data|Filter|Autofilter Use a custom filter of equals X (or contains X--depending on what you meant). And then copy those visible rows and paste to the new worksheet. Toddmend wrote: What statement would I use if I want to search a exce data base and find all rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd -- Dave Peterson |
#5
|
|||
|
|||
Maybe a macro you can run on demand (after you've validated your input???).
I'd steal some code from Debra Dalgleish's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or maybe Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Toddmend wrote: But I want this to be an ongoing database. I would like it to be a formula where I can enter something inew n the main database, and then if it has "X" in that colum, it will automatically be brought to the "X" file (which is a seperate file) -- Todd "Dave Peterson" wrote: I'd apply Data|Filter|Autofilter Use a custom filter of equals X (or contains X--depending on what you meant). And then copy those visible rows and paste to the new worksheet. Toddmend wrote: What statement would I use if I want to search a exce data base and find all rows that have "X" in one colum. I want to take those rows that contain "X" and copy the entire row into another excel document. Any ideas? -- Todd -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |