Threads Replies Last Post 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   how do I figure a 15% projected increase of current quotas? I have entered a formula which figures a 10% projected increase in current quotas. Now I am supposed to change it to a 15% projected increase. I thought if I just changed the number from 1.1 to 1.15 I could get the new numbers, but it didn't work.... 4 09.09.2006 04:57:01 A Problem with Fill Colors We have a user who needs to fill various cells with a different colors. When ever the file is opened, the colors change and she needs to reset them to conform to a predetermined Legend. What could possibly make the colors change? I am at a loss to explain this to her or to correct the problem. Than you for any help.... 2 09.09.2006 01:04:47 how to update data displayed from a UDF when the source data chang I have a workbook that I am trying to use a user defined function to always reference the previous sheet so I can make several copies of the sheet to cover a 52 week period. I have made it this far. However when I change the data and then go to the next sheet the calculations do not automatically update. I have tried to refresh the data and re-calculate the sheet but the calculation d... 3 09.09.2006 00:38:02 How do I make my top margins bigger? I am doing a spread sheet for work and want to make my top margins bigger, so I can add wording in them. Help!... 2 08.09.2006 23:50:56 default save directory for a templated worksheet Is there any easy way to automatically have a template save to a particular location for that template only? e.g the 'Quotes' template saves to the quote directory the Orders template saves to the orders directory Thanks Mike ... 3 08.09.2006 22:08:33 Is there a MOVE operator like IF, AND, etc? -- SgtBob... 5 08.09.2006 21:46:08 pasting beyond 64000 lines I have large txt. data sheets as many as 3 to 400000 lines that i would like to paste into multiple sheets ... 4 08.09.2006 19:49:02 Copying code New to VBA so ... I have copied some of the great code from CPearson.com. If I open a new workbook and add the code to a new module. it works for that workbook (only). What I want to do is add it to personal.xls so it works in all workbooks. I can't get this to happen. I add a new module to personal.xls, copy the code and it doesn't work. Other macros that I have in Personal.xls work... 5 08.09.2006 19:00:55 Copy of Word document Why does a 25 page Word Document appear to have 400+ pages when I copy it to Excel? Obvious slow down!... 2 08.09.2006 17:09:45 Automatic/Manual Calculation Using Excel 2002, I am set to Automatic calculation. One, and only one file always indicates it requires Manual calculation. I am sure it is something within the file, but am not sure what to look for. Can someone give me some guidance on what steps to take to correct the problem. Thanks, as always. Paul... 5 08.09.2006 15:04:03 Shortcut keys for Aligning Wanted to know the shortcut keys for Left, Centre and Right Aligning text in a cell in in MSExcel2003.... 2 08.09.2006 10:34:50 using checkmark symbol shows only # not check mark Excel 2003 I am using the Dingbat font. All stars and other symbols are OK, however, when I use the checkmark, or X symbol it only inserts the a number and not the symbol. Thanks.... 2 08.09.2006 08:46:16 MVP's, please help me understand SUMPRODUCT. Please refer to Ntobias' thread on Aug 24, 2006 and Sandy's comment before you read on. Sandy, Thank you for your comment and a different perspective. Before JE's post, I already had a hard time understanding SUMPRODUCT. When I read JE's post I did more research. Excel help was not a big help and I got lost in cyber space encountering things like matrix Algebra. To make a long story ... 16 08.09.2006 08:03:44 IF Statement with Date data Hi I run Win2k with Excel 2K I would like to have a formula that looks at a range of dates, then determines the "latest" date in that range. Then if that "latest" date is greater than 30 days from the "current" date, display a message "DUE". If your require anymore info please let me know. Thanks John... 9 08.09.2006 04:37:37 fill all cells in row with one cell entry I have a range of cells and in that range If I enter any type of text/number I want the rest of the row that cell belongs to, to be blacked out or marked somehow to show that, that row has an entry in it already. Is this possible. Please help. thank you.... 3 08.09.2006 02:49:48 Can I highlight a cell and link it to another workbook? I need to highlight one cell and link it to another cell in a different workbook where I want to enter a text definition of the first cell. I don't think linking works because that just gives me the same information in a different cell. I want to be able to click on a cell in one worksheet and be able to "flip" to its definition in another worksheet. Thanks! -- Jenn... 2 07.09.2006 23:07:02 AUTO SUM I USED AUTO SUM TO TOTAL SUBSECTIONS OF A COLUMN. THE FIRST 2 SHOWED THE TOTAL CORRECTLY: THE LAST 2 SHOW "#####" IN THE CELL. IF YOU PRINT THE WORKSHEET, THE CORRECT TOTAL PRINTS IN THOSE "#####" CELLS. WHAT AM I DOING WRONG?... 3 07.09.2006 21:14:01 How do I disable cookies? How do I disable cookies? Should I routinely try to do this? And all of them? My present problem is that i cannot open the list of articles on e -reserve from my school. I can get to the point where all the needed articles are listed, but once i try to open one, it does not give me the page where i am supposed to give my library barcode and id. From one of the school computers it works. ... 2 07.09.2006 20:33:15 Macro - Stop Recording toolbar I click on tools>macro>record new macro and the record macro dialogue box appears. According to this link http://tinyurl.com/l6xze, when I finish inputting the info into the dialogue box and click ok, the Stop Recording toolbar should appear on the screen. But this is not the case for me. What settings should I change to allow this to happen? I know alternately I can do view>too... 5 07.09.2006 16:56:08 Is there any utility to convert pdf data (tables) into excel? There is database in pdf format consisting of about 50000 records. Is there utility inl to convert it into xls (excel) format? ... 4 07.09.2006 16:49:39 What does it mean define ranges in Excell for import I am trying to use an Excell database of names to be used in Outlook and it asks for defining of ranges . Its a one column. I dont understand. Please help... 3 07.09.2006 16:38:22 How do I print the 1st column as a row header in each page? This is a simple question that I could not format correctly in order to get an answer from the Help file. Duh...would someone please point me to the proper Help topic? Thank-you!... 10 07.09.2006 03:28:16 How do I get my Quattro Pro 10 files to open with Office Excel? My .qpw files will not open in Office Excel 2003; file format is not valid. I did find a fix for Quattro Pro 7 to Excel 2000, but did not try that for obvious reasons. Also, is the best way to move spreadsheet files from one computer to another via cd? Thank you all in advance. ... 2 07.09.2006 02:55:55 calculate taxes I have columns of sale items that need to have two taxes 7% & 6% added to them. I can do one by but not sure how to combine them. ie 100+7+6=113. What is the formula for this. I am relatively new to this.... 5 07.09.2006 00:58:06 In Excel formula to calculate the date someone will hit 65 Using a formula, calculate from birthdate what date a person will turn 65.... 4 07.09.2006 00:56:01 125 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>