Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NSoulBri

    transfer excel to word...format gone

    Whats wrong with simply, Insert/Object...Create from file/Browse. Don't you want the entire sheet? Bri [afro]"Soul music is for life, not just christmas"
  2. NSoulBri

    excel references for count possible lookup??

    I think you're talking about the SUMIF function but I don't fully understand your question. Do you just want to add up all A1:A100 or just the ones that meet a certain UserID criteria? If the latter is the case then you want the SUMIF Function and it takes the form...
  3. NSoulBri

    Excel Data entry conditional on previous entry

    Hats off to xlbo [thumbsup2] Your solution to bilko1s' question is far better than mine You deserve a star Bri [afro]"Soul music is for life, not just christmas"
  4. NSoulBri

    Strange thing in word has happened

    I don't think the problem is with normal.dot, however if you want to eliminate that being a problem then just rename it, restart word, try to open a *.doc If sucessful then normal.dot was corrupt, if not then it's back to the drawing board. Just bear in mind your own personal settings that you...
  5. NSoulBri

    Strange thing in word has happened

    I thought maybe there was a registry setting that told word that the default filter for file types was *.doc but I can't find one There is a setting in Tools/Options... in Word that lets you specify the default filter when saving files but not one for opening. When you say you can't see .docs...
  6. NSoulBri

    Change case in Excel

    the quickest solution is to repeat the column and convert to uppercase all in one go Suppose column A contains your original lowercase stuff. in cell B1 type the formula =UPPER(A1) and copy down to all relevent rows column B now contains an uppercase version of column A Hope this helps Bri...
  7. NSoulBri

    Excel Data entry conditional on previous entry

    The only response I can think of here is to use VBA to set the validation of cell B1 to "BBB" OR "CCC". If the validation of B1 was NOT dependant on the value of A1 then it would be a simple case of: Data/Validation... Then settings as follows: Allow = List Ignore Blank =...
  8. NSoulBri

    Labels in Excel

    Good Morning Skip Did you sleep well? (If at all) In a way I'm glad I've caused you all a problem with this because it's been buggin' me for ages and I thought maybe I should give up training as a bad job because I don't understand the product I'm trying to teach to others. Fully...
  9. NSoulBri

    Labels in Excel

    I thank you for your response Skip but once again the example you have given does not require you to use Insert/Name/Label... the stacked column headings will be detected automatically If you create a stacked heading, put some values in that column and then do =Sum(Projected West) then as long...
  10. NSoulBri

    Labels in Excel

    To best try to illustrate my point, Please follow these steps. (It will take you about 2 minutes) Create a new worksheet Go to Tools/Options... and on the Calculation tab check the 'Accept Labels In Formulas option and click OK. Enter Info into the spreadsheet like this: Row 1 contains Word...
  11. NSoulBri

    Power Point Problem

    Is the microphone you are using compatible. ie is it a PC Mike? Is the Recording section disabled in Control Panel/MultiMedia? Is the Preferred Device in the Control Panel/MultiMedia option set to a specific device or "(Use any available device)"? If you can click on the Microphone...
  12. NSoulBri

    Labels in Excel

    Thanks to JVFriederick for your comments The method you appear to suggest is Insert/Name/Create... which I fully understand and use frequently. This is my interpretation of your suggestion. Please correct me if I'm wrong. Column headings in row 1 are EndingDate, ClassDescription, TimeTable...
  13. NSoulBri

    Labels in Excel

    Thanks again, it's nice to get such a quick response, this is more like chat than forum init? However, I'm still confused, or maybe you are, or maybe we both are. afterall we are talking about MS here. Can you explain why I would do Insert/Name/Label... instead of Insert/Name/Create... I've...
  14. NSoulBri

    Labels in Excel

    I appreciate your speedy response Dreamboat but I would use the Insert/Name/Create... command to do what you propose, not the Insert/Name/Label... command Bri "Soul music is for life, not just christmas"
  15. NSoulBri

    Excel Clear Contents of Row

    Unless I'm missing the point the remedy here is simple. Format the entire sheet first and copy your '% to goal' formula all the way down. Bri "Soul music is for life, not just christmas"
  16. NSoulBri

    (Probably) A simple Excel transpose data question

    I'm not entirely sure what you are trying to achieve but the 'Paste Special' feature would allow you to simply paste the values of the cells and not the formulas. When you say 'transpose' do you mean literally. ie transpose vertical to horizontal or vice versa or do you mean simply paste what...
  17. NSoulBri

    Labels in Excel

    Can anyone explain the point of labels in excel. I fully understand the point of naming ranges and constants etc but fail to understand why you would want to label a range of cells when Excel already provides labels automatically via the placement of row and column headings. To explain my...

Part and Inventory Search

Back
Top