General

AUTO CORRECT PROBLEM
I am working in Excel 03. I am constructing a large database whereby in certain cells when an individual enters A, E or P it is auto corrected to a numeric value. To my horror these auto corrections have carried on in Word, Outlook and PowerPoint. How do I restrict these autocorrects to just the spreadsheet I a... 8 Jul 2008 11:03

Easily extracting data from one spreadsheet to another
Hi everyone, i'm hoping someone can help me out... I have a spreadsheet with the data I want, what i need to do is extract the data from each row, or in one or two cases range of rows, to a seperate sheet for each one. Is there a simple way for me to do this without having to copy and paste each one manualy? ... 8 Jul 2008 08:59

Excel not updating values?
This works but only for a while then it reverts back to manual.....anyone any ideas? "Gary''s Student" wrote: Tools > Options > Calculation > automatic -- Gary''s Student - gsnu200779 "Riptide" wrote: When using the sum formula, if I made a change to one of the values in the c... 8 Jul 2008 13:06

Adding to drop down lists
Once i have named a list that will become my drop down list, how would i add extra selections after i have made the list? ... 8 Jul 2008 10:01

Private Sub - Only Accessible from same Module?
This is more a confirmation than a question.... If I have a Public Sub that calls on another Sub which is Private, if the Private Sub is not in the Module then an error appears. My question then is why doesn't excel2003 allow for cross-module Private Subs to be called upon? It seems to me like it makes sense... 8 Jul 2008 10:01

Copying forward a number
Every day I do a reconciliation where I have to copy the figure from the previous day's rec (B35), then subtract a figure from today's rec (B9) and add a figure from another cell also in today's rec (D9) to give me the new figure in B35. There are a number of worksheets and I have to do it for every worksheet.... 8 Jul 2008 03:53

How do I put spaces in a field
Office 2003 & 2007, Win XP Pro I have a list of telephone numbers eg: 0117839178 0866610689 0917142591133 I wish to convert them to: 011 783 9178 086 661 0678 091 714 259 1133 All numbers begin with zero. Much appreciated. ... 8 Jul 2008 04:54

Grouping & Outline
I have been using Excel 2003 for a while on a desktop. Have a new Laptop now and cannot find the Grouping Tab. Finally found it under Draw toolbar, but it is disabled. How do I enable it. Also earlier could get the grouping tab by right clicking the selected rows / columns. This is not available. What can be do... 8 Jul 2008 12:04

Average / sumproduct based on multiple criteria
Hi guys, I have 3 columns. Column A contains the category lables "cat", "dog","goldfish","mouse", column B contains a further category lable, ie 1, 2, 3, or 4 depending on their assigned grade, and column C contains a variable value. I need to average the variable values in column C only if they meet two of... 8 Jul 2008 02:52

How do I retrieve a file deleted in error?
... 8 Jul 2008 23:23