| Thread | Last Post | Replies |
|
| Given a Row and a Column I would like the Range reference | 18 Sep 2007 16:25 GMT | 5 |
I'm inserting a custom user defined function into a cell. As a parameter to the function is a cell which is the cell in which the function is located i.e.
|
| How do I remove a summation line? | 18 Sep 2007 16:17 GMT | 2 |
I did a summation on a column of numbers and a summation line was left of my speadsheet. How do I remove it?
|
| How to send just one page of a multi-page workbook? | 18 Sep 2007 15:26 GMT | 1 |
Is there a way to email just one page of a workbook? Recently, I was asked to do so and I ended up selecting that page, copying it, and pasting it into a new workbook which I then sent as an attachment. Is there an easier way? Thanks for your help.
|
| Create Index for Excel Inventory List | 18 Sep 2007 15:24 GMT | 2 |
At this time I have about 30 worksheets in my inventory workbook. Each worksheet is of a specific inventory catagory such as one worksheet will be switches, another would be converters etc. I expect to have over 150 sworksheet entries by the time I'm done. I need to have a ...
|
| User defined functions aware of what cell they are placed in? | 18 Sep 2007 14:26 GMT | 2 |
I would like to make a user defined function which needs to know in what cell and what worksheet it is placed in. I will be using this UDF in multiple cells on multiple worksheets. I originally just passed the cell row and column as parameters to the UDF however this ended up
|
| Mail subject from Excel range | 18 Sep 2007 14:14 GMT | 3 |
Hey fellows I try once more to beg for help. Franz har earlier given me a link to explore (thanks Franz), but my efforts in exploring this has resulted in no success.
|
| I have the template i want to use, however I am not sure how to us | 18 Sep 2007 14:07 GMT | 1 |
an e-mail was sent to me with a spreadsheet I'm to complete. A co -worker helped me to create a template of that spreadsheet that I need to fill in but I don't have experience using templates. How do I get started, and how do I create a next page or sheet?
|
| Pivot Tables - mulitple consolidation ranges | 18 Sep 2007 13:16 GMT | 1 |
Hi - I created a spreadsheet in Excel 2003 that contained a pivot table. The table was created using the wizard - I am using it to 'undo' a two way table so when I created it I chose Multiple Consolidation Ranges
|
| Excel 2007 - How do I edit text like the old Edit / Fill / Justif | 18 Sep 2007 13:06 GMT | 1 |
The same Edit / Fill / Justify doesn't seem to work the same in 2007 as it does with XP when editing long text in a cell to fill below. Any suggestions?
|
| Sorting based on IF statement *please help me!* | 18 Sep 2007 11:14 GMT | 1 |
I'm trying to create a macro which will sort a table 1st based on an IF statement and then by a due date. What I'm trying to do is sort the table so that any complete tasks (signalled by a "Yes" in the designated column) will be pushed to the bottom of the list and the
|
| Variable chart Source Data Y Values | 18 Sep 2007 10:50 GMT | 1 |
I can't seem to encode the Y-Values of a chart to have a variable range. (in Excel 2000) I have tried things like: ="INDIRECT( CONCATENATE( "Sheet1!$A$1:$A$", TEXT($B$1,"0") ) )"
|
| can you add some better animation features in your poweroint ? | 18 Sep 2007 10:44 GMT | 1 |
how to used excel formula ?can you send me all the details .
|
| very slow refresh or response time each time "enter" button hit | 18 Sep 2007 10:42 GMT | 1 |
No matter size of spreadsheet, each time I hit the enter button, I have to wait 5 or 6 seconds for the screen to refresh. It is a new grunty pc and all other office pro applications working fine, ie access very quick. t'is driving me crazy....
|
| Overlay | 18 Sep 2007 09:06 GMT | 2 |
I have two Excel spreadsheets. One contains a list of random email addresses (perhaps 100) that is extracted from another far more comprehensive list that includes address and contact details (perhaps 50,000). I would like to create a function/macro to overlay/highlight which ...
|
| Macro: Excel mail attachment - celle-value as Subject of mail | 18 Sep 2007 08:22 GMT | 2 |
Hey fellows! Here is my problem: I have made a macro to copy a range - (A1:K15) - into an attachment of an outgoing mail.
|