| Thread | Last Post | Replies |
|
| Running/Current time in cell? | 28 Sep 2005 21:45 GMT | 6 |
I know that if I enter CTRL+SHIFT; it will enter the current time of day. But...is there any formula out there that will insert the time of day and keep it current? (Basically a running clock, so that whenever the spreadsheet is open, cell A1 (for example) will always show the ...
|
| Strange VBA macro problem | 28 Sep 2005 21:39 GMT | 2 |
I have successfully created some VBA code to check for and create folders, and then save a file to that folder. However, when you pull up the excel sheet, complete your work, and then run the macro, it will not run on the first attempt. A run time error
|
| how do I create a spread sheet to automatically calculate when I | 28 Sep 2005 20:41 GMT | 2 |
On a new spread sheet I am entering numbers and I would like them to be multiplied and changed automatically. The formula is x*3 then less 40%. Can anyone help me.
|
| help in my project | 28 Sep 2005 19:54 GMT | 6 |
this is a big question and hope I'll find a help I enter in the cell B1 sheet1 the name of the material and in the cells from B2 to B10 the prices my question
|
| row selection - from current to last row | 28 Sep 2005 19:24 GMT | 3 |
I would like to be able to select rows from the highlighted one to the last row. How do I do that? Thanks Keith
|
| Skipping Columns/Rows | 28 Sep 2005 19:09 GMT | 2 |
Is it possible to skip a column or row when tabbing in a workbook? In other words, when I'm in A1 and I hit the tab key, I want to be in C1. P.S. -- I do not want to hide the columns as I'm an advocate of using the least amount of steps as necessary to produce a document. In other ...
|
| vlookup problem | 28 Sep 2005 17:45 GMT | 4 |
This one really blows me away! I just reinstalled ExcelXP and created a worksheet to determine a state value (D) from an area code(C) with the following columns: A B C D
|
| Custom function in an add-in problem! | 28 Sep 2005 17:37 GMT | 3 |
The add-in defines a custom function that returns a catalog price. The formula in the cell is "=CAT05("1234", Price). When the user that created the file opens the file, all is well. When another user opens the file we have problems. Even though all of our users have the same ...
|
| Excel Depth | 28 Sep 2005 17:19 GMT | 1 |
I have done a lot of R and D on excel, but whenever i see excel I definitely find something new... Excel is really really deep... Manish
|
| Is there a quick way to... | 28 Sep 2005 17:12 GMT | 4 |
highlighting only the odd or even numbered rows? Thanks.
|
| missing formula bar | 28 Sep 2005 17:09 GMT | 2 |
Hi I just opened excel and the bar at the top where you enter data and formula is missing. So if I want to enter data I have to enter it in the cell. How do I get this bar back and why did it disappear? Office XP with Excel
|
| How many sheets can I have in a spreadsheet | 28 Sep 2005 16:48 GMT | 1 |
I need to have 93 sheets in a spreadsheet to update the first page. Can I have that many?
|
| Looking for sheet for expenses and income | 28 Sep 2005 16:42 GMT | 1 |
Anybody has or knows where to find an Excel sheet to fill in all expenses and income for a small buss company? Bart
|
| Assign a Custom Toolbar to only one WorkBook | 28 Sep 2005 13:59 GMT | 3 |
Need Help: I am trying to assign a custom toolbar to only one workbook. The custom toolbar consists of several buttons each of which has a macros assigned. The macros are such that they only can be used in the one
|
| Link to macros (personal) on server | 28 Sep 2005 13:47 GMT | 1 |
Is there a way of putting the file (e.g., PERSONAL.XLS) that contains commonly used set of macros on the server and create a link (shortcut in the startup folder (on each separate user's PC). I have tried th following: (1) put PERSONAL.XLS on the the server (2) created
|