| Thread | Last Post | Replies |
|
| Making A Macro Generally Available | 26 Mar 2008 02:15 GMT | 15 |
I've written a macro (I'll call it Macro1) that multiple people will need to use. From Macro1, (that exists in my PERSONAL.XLS), I created an add-in on a common drive location and copied the code to Macro1.xla, thus creating Macro1.xla as an add-in. As a test, I
|
| Date format question | 26 Mar 2008 01:43 GMT | 3 |
There is a date format that will format a date like this: "Wednesday, April 09, 2008" Can i create a custom format that will do this: Wed, Apr 09
|
| Using formula based on text in a different cell | 26 Mar 2008 00:25 GMT | 1 |
Hello. I have a list of calculations that I have to perform each week and I decided to use excel to simplify the task. I will use generic examples. I have a group of agents which call on any of 4 different programs. We will say program A-D. Each program has a different goal. Each ...
|
| Meaning of "--" in formulas | 25 Mar 2008 23:31 GMT | 3 |
I sometimes see formulas with -- before a set of parenthesis (sample formula below), can anyone tell me what the purpose of it is? I can't seem to find it documented anywhere. For example:
|
| duplicate cells linearly? | 25 Mar 2008 21:31 GMT | 2 |
Is there a way to duplicate a formula in cells were the row reference grows linearly, instead of simply the number of cells? For instance, if you have in Sheet2 the formula Sheet1!$c1
|
| Lookup in 3 different columns beneath a merged header | 25 Mar 2008 20:57 GMT | 1 |
I have a production sheet where I controll the production of our 3 products by date like: a1, b1 and c1 are merged as date a2 prod1 b2 prod2 c2 prod3
|
| Create static text from cell reference | 25 Mar 2008 20:51 GMT | 2 |
Hey everyone... I have two columns of text which I'm combining in a third column using the formula (for C1, for example) =A1 & char(10) & B1 This gives me the contents of A1 on a line above the contents of B1 and
|
| Auto Filter Top 10 | 25 Mar 2008 20:48 GMT | 4 |
Using XP and Office 2003 Column A has a list of budget categories like "Administration" and "Payroll" and "Building Maintenance." Column B has the specific line item account breakdowns within each category.
|
| Newbie question / plug in a value for a cell based on a range for that value | 25 Mar 2008 20:32 GMT | 10 |
Hey guys, New to Excel so sorry if this explanation isn't the clearest in terms of correct terminology. In one section of my spreadsheet I have a list of percentage values
|
| I'm cluesless - need help with "functions"? | 25 Mar 2008 19:27 GMT | 5 |
I'm trying to transcribe information from timecards to a spreadsheet. The person who designed the spreadsheet for me only put in equations to row 46 (not nearly enough). Heres an idea of what it looks like since I am too uneducated on this program to know how to describe it. ...
|
| 100% cpu utilization during save as | 25 Mar 2008 19:20 GMT | 4 |
I'm wondering if anyone here can help me with this. When I'm typing a filename in the Save As dialog box in Excel 2003, excel.exe shoots up to 100% CPU utilization and it takes a second or two for the letters I've typed to show up. This only happens when I'm trying to save to a
|
| Excel | 25 Mar 2008 18:24 GMT | 5 |
I would like to modify the customized 'Excel Help' in the template 'Year-end tax planning calculator ' I found at Office Online Templates (http://office.microsoft.com/en-us/templates/TC100388541033.aspx ). Please help.
 Signature Brian
|
| Unable to remove the e-mail toolbar | 25 Mar 2008 17:49 GMT | 1 |
When I open a file on my desktop, the e-mail toolbar (the To:, Subject: fields, etc.) comes up and I can't turn it off. It is only for this particular workbook, all others are fine. In the "Display" tab, the Message toolbar checkbox is greyed out.
|
| Input Fiscal Year. | 25 Mar 2008 17:44 GMT | 1 |
I've been trying to create a formula that would convert a day into the current fiscal year, For instance, July 1st is the beginning of fiscal year 08, so if cell b3 reads 7/15/07, I would like cell a3 to read FY 08. Thanks in advance, David
|
| Excel does not perform sum totals on numeric values | 25 Mar 2008 16:32 GMT | 2 |
I have a colleague working with Excel 2000 (it's the Romanian version), and from time to time she is experiencing this issue: She is entering numeric values into a column and after that she is trying to sum all the values in the column (the very well-known SUM formula). Weird is
|