Search results for query: *

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"

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...

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"

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...

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...

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...

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 =...

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...

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...

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...

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...

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...

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...

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"

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"

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...

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...