| Thread | Last Post | Replies |
|
| Accessing macro from a system by all other nodes on LAN | 28 Jan 2008 14:37 GMT | 1 |
I have created a macro in a worksheet and stored in C:\program files\MSOffice\Office10\XL Start folder. Now I want to execute the macro whenever MSExcel is started from, the system on which it is stored and also on other systems in the network.
|
| 2003 startup | 28 Jan 2008 14:31 GMT | 1 |
Worked before the crash.. Excel 2003 should start with a blank worksheet from the "start" directory and not automatically save back to that directory. Told it to save to C:\Workfiles but if you save it when first opens up it changes the original start up file. Should be easy ...
|
| Sliding value bar? | 28 Jan 2008 13:43 GMT | 2 |
I thought I saw in an add-in or somewhere where a slide bar was added to an Excel worksheet, assigned a min and max value and associated with a cell. Then by sliding the bar you change the cell value and the values of cells using that whose formulas reference that cell. I am ...
|
| Chaning the Total Value of Filtered Projects | 28 Jan 2008 13:28 GMT | 3 |
Hello all i was wondering if you could help me, i have say two columns which column A is A3:A10 which have projects Names and then Column B3:10 have Tender Values. In Column A2 I Have the Field Name Projects Which has an Auto Filter
|
| Formating Problem | 28 Jan 2008 13:02 GMT | 1 |
I am working on a large spread sheet. Occasionally, it is necessary insert rows through columns which have already been formatted. Typically, some columns are totaled (summed) at the bottom. In the past, I have occasionally noticed (I think) that the sum of a column which has ...
|
| Adding or subtracting numbers from a column | 28 Jan 2008 12:41 GMT | 2 |
I would like to have a column of numbers and by typing in numbers in an adjacent column add these numbers to the ones in the column. As the numbers in the column change it would be nice if the ones I am typing in returned to zero. If anyone knows haow to do this I will be ...
|
| Can you exceed 15 number characters in an excel cell? | 28 Jan 2008 12:09 GMT | 1 |
I am trying to concatenate two cells which between them contain 16 numbers. However in the concat, the last number is being replaced with 0. I have found that a cell can only contain 15 number characters, is it possible to exceed this to 16 characters and if so, how? Thanks.
|
| Prevent duplicate entries in Excel 2000 | 28 Jan 2008 09:07 GMT | 11 |
I'm trying to create data validation to prevent users from entering duplicate rows in Excel 2000. I tried this also with conditional formatting to turn the newly entered line red, which didn't work either. This is a name and address list where I want to check the first name(B),
|
| help!!! | 28 Jan 2008 05:19 GMT | 1 |
i'm trying to build a budget and i need help.........can someone tell me how can i put a fix number into a cell of a number that i don;t know yet.... for example I want to allocate 100 into food out of my income cell (B12), but because my
|
| Adding Rows or Columns without harming formulas. | 28 Jan 2008 04:59 GMT | 2 |
Thank you for taking my question! First, I work for a non-profit. A campaigner is someone that is helping to solicit donations. We have 40 campaigners and each campaigner is assigned prospects. So say rows 2-15 are bob's prospects then row 16 is where his
|
| subscribe | 28 Jan 2008 04:27 GMT | 6 |
|
| Save file as Cell Value | 28 Jan 2008 04:02 GMT | 2 |
I have the below routine set to copy a page to my desktop. Is there a way to have it change the save name to a particular cell's value? If Range(“L6”) equals a certain word, I would like it to save as that particular name. Thanks in advance for your thoughts - Roger
|
| What is this Excel feature? | 28 Jan 2008 03:03 GMT | 3 |
When I look at the MS Office Template called LoanAmortization1 (for Excel 2007), it has a feature that I do not recognize. What is it? How was it created (i.e. what keystrokes)? And how can I edit it? Is this feature limited to Excel 2007?
|
| change color of all cells with formula or are part of a formula | 28 Jan 2008 01:21 GMT | 19 |
is it possible to change the color of all cells that contain a formula or are part of a formula??? if so, how would i do that?
|
| Trial only | 27 Jan 2008 23:35 GMT | 1 |
Trial only to see how my questions will appear. Please do not answer.
|