Is thr way in Excel to "find" all cells tht cntain spcfic value, .
Sorry about the spelling... had to make it fit.
I want to do what "edit - find" does, except print the resulting rows that contain the cells it finds. Is there a way to do this? i.e., search for all rows with "hello" in a cell in column "greeting", say, then hide all the other rows except these. Thank you for your time on this. |
Hi John
check out data / filter / autofilter go to the drop down arrow on the greetings column and choose "hello" to get all your records back, clear the autofilter (data / filter / autofilter) or choose data /filter / show all Cheers JulieD "John Chaffey" <John wrote in message ... Sorry about the spelling... had to make it fit. I want to do what "edit - find" does, except print the resulting rows that contain the cells it finds. Is there a way to do this? i.e., search for all rows with "hello" in a cell in column "greeting", say, then hide all the other rows except these. Thank you for your time on this. |
Thank you, Julie.
I've tried that, but I have multiple codes in single cells (e.g. SA1, AD2, etc etc). "Edit - Find" will find all the SA1's, say, and identify the cells that contain them, but won't let me print the results of the search. I could have 40 separate columns, each with a single code, but that would create a very wide spreadsheet. If I *did* that, could I make the other 39 columns disappear? Thanks Maybe I need Access to do this.... John On Mon, 21 Mar 2005 23:53:25 +0800, "JulieD" wrote: Hi John check out data / filter / autofilter go to the drop down arrow on the greetings column and choose "hello" to get all your records back, clear the autofilter (data / filter / autofilter) or choose data /filter / show all Cheers JulieD "John Chaffey" <John wrote in message ... Sorry about the spelling... had to make it fit. I want to do what "edit - find" does, except print the resulting rows that contain the cells it finds. Is there a way to do this? i.e., search for all rows with "hello" in a cell in column "greeting", say, then hide all the other rows except these. Thank you for your time on this. |
Hi John
data / filter / autofilter - CUSTOM contains SA1 or put them in the multiple column and then hide the columns as needed as for Access ... mmm quite a steep learning curve (good fun though) ... there's a thread at http://tinyurl.com/48rze which is a recent discussion about when to move to access .. Cheers JulieD "Grampa Tom" wrote in message ... Thank you, Julie. I've tried that, but I have multiple codes in single cells (e.g. SA1, AD2, etc etc). "Edit - Find" will find all the SA1's, say, and identify the cells that contain them, but won't let me print the results of the search. I could have 40 separate columns, each with a single code, but that would create a very wide spreadsheet. If I *did* that, could I make the other 39 columns disappear? Thanks Maybe I need Access to do this.... John On Mon, 21 Mar 2005 23:53:25 +0800, "JulieD" wrote: Hi John check out data / filter / autofilter go to the drop down arrow on the greetings column and choose "hello" to get all your records back, clear the autofilter (data / filter / autofilter) or choose data /filter / show all Cheers JulieD "John Chaffey" <John wrote in message ... Sorry about the spelling... had to make it fit. I want to do what "edit - find" does, except print the resulting rows that contain the cells it finds. Is there a way to do this? i.e., search for all rows with "hello" in a cell in column "greeting", say, then hide all the other rows except these. Thank you for your time on this. |
Perfect!! Many thanks, Julie
It works like a charm. I *did* spend a day exploring Access, but ... I fell off the learning curve. Thanks again John On Tue, 22 Mar 2005 01:18:16 +0800, "JulieD" wrote: Hi John data / filter / autofilter - CUSTOM contains SA1 or put them in the multiple column and then hide the columns as needed as for Access ... mmm quite a steep learning curve (good fun though) ... there's a thread at http://tinyurl.com/48rze which is a recent discussion about when to move to access .. Cheers JulieD "Grampa Tom" wrote in message .. . Thank you, Julie. I've tried that, but I have multiple codes in single cells (e.g. SA1, AD2, etc etc). "Edit - Find" will find all the SA1's, say, and identify the cells that contain them, but won't let me print the results of the search. I could have 40 separate columns, each with a single code, but that would create a very wide spreadsheet. If I *did* that, could I make the other 39 columns disappear? Thanks Maybe I need Access to do this.... John On Mon, 21 Mar 2005 23:53:25 +0800, "JulieD" wrote: Hi John check out data / filter / autofilter go to the drop down arrow on the greetings column and choose "hello" to get all your records back, clear the autofilter (data / filter / autofilter) or choose data /filter / show all Cheers JulieD "John Chaffey" <John wrote in message ... Sorry about the spelling... had to make it fit. I want to do what "edit - find" does, except print the resulting rows that contain the cells it finds. Is there a way to do this? i.e., search for all rows with "hello" in a cell in column "greeting", say, then hide all the other rows except these. Thank you for your time on this. |
you're welcome ... and thanks for the feedback ... :)
"Grampa Tom" wrote in message ... Perfect!! Many thanks, Julie It works like a charm. I *did* spend a day exploring Access, but ... I fell off the learning curve. Thanks again John On Tue, 22 Mar 2005 01:18:16 +0800, "JulieD" wrote: Hi John data / filter / autofilter - CUSTOM contains SA1 or put them in the multiple column and then hide the columns as needed as for Access ... mmm quite a steep learning curve (good fun though) ... there's a thread at http://tinyurl.com/48rze which is a recent discussion about when to move to access .. Cheers JulieD "Grampa Tom" wrote in message . .. Thank you, Julie. I've tried that, but I have multiple codes in single cells (e.g. SA1, AD2, etc etc). "Edit - Find" will find all the SA1's, say, and identify the cells that contain them, but won't let me print the results of the search. I could have 40 separate columns, each with a single code, but that would create a very wide spreadsheet. If I *did* that, could I make the other 39 columns disappear? Thanks Maybe I need Access to do this.... John On Mon, 21 Mar 2005 23:53:25 +0800, "JulieD" wrote: Hi John check out data / filter / autofilter go to the drop down arrow on the greetings column and choose "hello" to get all your records back, clear the autofilter (data / filter / autofilter) or choose data /filter / show all Cheers JulieD "John Chaffey" <John wrote in message ... Sorry about the spelling... had to make it fit. I want to do what "edit - find" does, except print the resulting rows that contain the cells it finds. Is there a way to do this? i.e., search for all rows with "hello" in a cell in column "greeting", say, then hide all the other rows except these. Thank you for your time on this. |
All times are GMT +1. The time now is 02:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com