| Thread | Last Post | Replies |
|
| Excel users | 21 Apr 2008 15:43 GMT | 2 |
I have Excel and Word on a server for multiple users. On some computers some users can access Excel and Word without problem while other users have to "Load" Excel or Word before opening an existing workbook or document. These same users have no problem on a different computer on ...
|
| How do I get an inserted symbol to show in another worksheet? | 21 Apr 2008 14:04 GMT | 1 |
If I have a worksheet where there is a trend column that uses inserted symbols (eg arrows) to show the trend, how do I get that symbol to show in another worksheet that has a formula to return data from a specific cell (eg the one with the symbol in it).
|
| PC macros won't work on MAC | 21 Apr 2008 13:58 GMT | 2 |
I spent the last month working on a large workbook in Excel 2003 and it has all sorts of macros in it. It works great on PC versions of Excel. However, the macros are not working when MAC users open the workbook. Also, the formatting of the MAC file is a bit off. Is there an ...
|
| Copying Data from One Worksheet to Another | 21 Apr 2008 13:32 GMT | 2 |
I am wanting to put the data in a specific row to worksheet 2 or 3 drivin by a formula. If row one in the a column has a 2 I want the whole row of data to copy to sheet 2 and if row one in the a column has a 3 I want the whole row to copy to worksheet 3.
|
| Explain how data is stored in excel in your own | 21 Apr 2008 13:10 GMT | 1 |
Explain how data is stored in excel in your own
|
| Cell Referencing | 21 Apr 2008 13:09 GMT | 5 |
Is it possible to reference cells in Excel using numbers for both rows and columns rather than the letter and number reference as is standard? If so, is it possible to write a macro that selects range A1 to A+X:1+Y where X & Y are variable integers in other cells?
|
| Auto Fill...Is it Possible? | 21 Apr 2008 13:04 GMT | 5 |
In column A, I have, in alphabetical order, say, 1000 cities...in A1 through A1000. How is it possible to scroll directlt to "Manila", for example?? If I begin to type Manila in a cell, say cell D1, can I 'scroll' directly
|
| ComboBox ListFillRange | 21 Apr 2008 12:55 GMT | 14 |
Why a horizontal range, e.g like A1:G1 cannot be used in ComboBox ListFillRange? Is there a workaround for that? Another question: can an OFFSET function or a named range be used in
|
| Subtotal show more columns | 21 Apr 2008 12:34 GMT | 1 |
When you use subtotal the output is only 2 columns, what you subtotalled on and your value or whatever you chose to calculate. How can I see other columns information as well on the subtotal line? I do realize the lines can be different but how would Excel handle this situation ...
|
| Conditional format for future date | 21 Apr 2008 11:49 GMT | 2 |
I have entered todays date into a cell and I would like that cell to change colour 2 months in the future. I know I have used =TODAY()-60 for dates equal to or greater than than 2 months past. What would the formula be for a future date?
|
| Returning zero if the results of a formula is a negative number? | 21 Apr 2008 11:08 GMT | 7 |
How do I get a simple addition formula to return a zero in a cell if the formula yields a negative number?
|
| FORMULA/FUNCTION TO LOCK AND UNLOCK A CELL | 21 Apr 2008 11:03 GMT | 2 |
I AM TRYING TO LOCK A CELL DEPENDING UPON THE VANUE THAT HAS BEEN RETUREND FROM ANOTHER CELL.fOR EXAMPLE IF CELL a13 RETURNS 1 THEN CELL a14 SHOULD BE LOCKED SO THAT NO ONE CAN CHANGE THE CELL. PEASE HELP
|
| SumProduct | 21 Apr 2008 11:00 GMT | 2 |
i've got two identical work books (one for 2007 and one for 2008) I have a sumproduct formula that works in the 2007 workbook but not in the 2008 workbook. I get a #value error in the 2008 workbook. The formula is:
|
| Saving as .xlt | 21 Apr 2008 10:33 GMT | 1 |
Hi, I have made a form with several formulas, have locked those cells with the formulas and have protected my sheet. When I save as .xlt one particular cell loses its formula, can anyone help
|
| Can anyone ! | 21 Apr 2008 07:03 GMT | 1 |
I have range in A1 : B10, Col A - Names Col B - production data In a day ( 8 hour work), I need to update data on every 2 hour in a
|