| Thread | Last Post | Replies |
|
| determining user-defined chart definition | 25 Mar 2005 15:17 GMT | 1 |
How can I look at the code/description of a user-defined chart?
|
| How do i make doctor's duty rota in the hospital? | 25 Mar 2005 13:22 GMT | 1 |
how do i make Duty rota for doctors using MS office.? Please help it is difficult to make fairly distributed rota according to sequence and equal owrking hours.
|
| IF help | 25 Mar 2005 07:31 GMT | 1 |
I am building a calendar that records events by month. For example I would type an event in the Jan 04 cell. I would like to have the Jan 05 cell return the entry with an ³04² in front of it. I am able to use the IF function to return the value in the Jan 05 cell
|
| Vlookup from First Three Characters of Codes | 25 Mar 2005 04:51 GMT | 6 |
I have posted this on Excel WorksheetFunctions. No help yet.. therefore posting it here.. Can somebody help me Thanks Hello All,
|
| Property? | 25 Mar 2005 04:09 GMT | 1 |
In an example referenced by another posting I found a lot of code that looks like: Property Get ChartSeries() ChartSeries = CurrSeries
|
| How do I force a reload of the workbook? | 25 Mar 2005 01:56 GMT | 1 |
I want to execute an occasional reload of a workbook, reverting to the last saved version, discarding any current changes. I tried the Refresh command from the Web toolbar but this doesn't always work - it becomes greyed out/unavailable.
|
| sound files in excel? | 25 Mar 2005 01:06 GMT | 1 |
Is there a way to put a wav file into an excel spreadsheet? Like in it's own cell, like how you can do with a clip art graphic?
|
| Displaying a ratio | 25 Mar 2005 00:36 GMT | 5 |
Is there a way to display a calculated ration such as 14.5:1? Example: Liabilities in cell D23 (28000) divided by Equity (25000) in cell D28 = 1.12 How do I convert that to a ratio? Or display it as a ratio?
|
| insert worksheet | 24 Mar 2005 23:51 GMT | 2 |
How do you insert a worksheet after the last worksheet?
|
| How do I properly attach vba code to a workbook | 24 Mar 2005 23:39 GMT | 2 |
I have a function and entered it into the vba editor, syntax and all is clean, but my spreadsheet won't recognize the new command when I go to use it. displays #name? etc. etc. This is my first time to actually use the vba editor, so obviously I'm missing some basics somewhere.. ...
|
| Concananate Function for Multiple Rows | 24 Mar 2005 23:18 GMT | 4 |
Everyone, I am looking to take text data from Column 1, Column 3, and add text after these values for every row in my spreadsheet. Is there a universal equation that I can use instead of having to insert values from each row individually
|
| conditional formatting | 24 Mar 2005 23:13 GMT | 1 |
i have conditional formatting on a cell. the cell will turn green based on another cells value (if it changes to 0). so cell 1,C will be green if cell 1,F is 0. is there a way to copy this formating and paste to cells 2,C through 20,C.
|
| SUMPRODUCT | 24 Mar 2005 22:33 GMT | 6 |
Can anyone help me? A while back Biff supplied me with a formula that found a city name in two different counties and added them together. =sumproduct(--(index(ilsort,,1)="chicago"),--(index(ilsort,,2)="cook")+(index(ilsort,,2) = "page"),index(ilsort,,4))
|
| Cells don't display color - Anyone know why? | 24 Mar 2005 22:19 GMT | 3 |
I have a user who is not able to see the color formatting of the cells unless he shows the worksheet in print preview mode. For example, he'll select a range of cells and will color them yellow. Nothing appears to change, however, if he does a print preview, he can see the ...
|
| Excel will not recognise Macro | 24 Mar 2005 22:06 GMT | 4 |
Ladies & Gentlemen, A small problem which is either me being stupid or Excel. I have borrowed some code from David McRichie's site which I have then pasted into a Module in the VBA Editor window. When I click on the Run
|