 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Searching for non-blank cells
I've been manipulating a fair amount of data. In some instances I have been cutting some data out of a worksheet and pasting it into another one. Just when I think I have all the data out of the central worksheet, I find some more data that is quite a few cell rows down. Is there a way that I ask excel to search for the next cell with some data in it - without knowing what that data is? You can try "Go To". <F5> <Special>, and choose "Constants", then <OK>.  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I've been manipulating a fair amount of data. In some instances I have been > cutting some data out of a worksheet and pasting it into another one. Just [quoted text clipped - 3 lines] > Is there a way that I ask excel to search for the next cell with some data > in it - without knowing what that data is? this website should help you http://www.cpearson.com/excel/noblanks.htm > I've been manipulating a fair amount of data. In some instances I have been > cutting some data out of a worksheet and pasting it into another one. Just [quoted text clipped - 3 lines] > Is there a way that I ask excel to search for the next cell with some data > in it - without knowing what that data is? I have a table of data, with the heading like Author ,Name of Books, Publisher, Subject. Now I want to search data. Subject wise . Like If I give History then I want all books under history subject.. & I want to do this under a drop down box. ??? Maybe you could select your range and apply data|filter|autofilter. Then you could filter to show a particular subject. Or click on the Custom option and use a criteria of "contains History". > I have a table of data, with the heading like Author ,Name of Books, > Publisher, Subject. Now I want to search data. Subject wise . Like If I give > History then I want all books under history subject.. & I want to do this > under a drop down box. ??? SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.