| Thread | Last Post | Replies |
|
| Excel 2007 Bug .XLK Auto Recovery | 25 Mar 2008 16:17 GMT | 11 |
Auto Recovery is suppose to save a temp file to C:\Documents and Settings\[username]\Application Data\Microsoft\Excel. I set it up in Excel Options to save the Auto Recovery files in that location. However, when I close an Excel 2007 file (that I've saved in My Documents), there ...
|
| Calculating Hours and minutes | 25 Mar 2008 15:49 GMT | 5 |
I am needing to calculate how long an item was used for using hours and minutes. Is there a formula or format that will let me do this. The total will go into thousands of hours.
|
| Calculating Hours | 25 Mar 2008 14:52 GMT | 1 |
I am looking to calculate hours and minutes. I want to calculate how long something has been running for by adding hours and minutes every week to the total. The problem is it stops counting after about 1000hours. is there a formula
|
| the code is not respond | 25 Mar 2008 12:46 GMT | 5 |
I have this code and it is working very well when I fill cells manually Private Sub Worksheet_Change(ByVal Target As Range) If Selection.Count > 1 Then Exit Sub If Not Intersect(Target, Columns("L:L")) Is Nothing Then
|
| Extra Rows in Excel 2007 | 25 Mar 2008 11:46 GMT | 1 |
I recently upgraded to Excel 2007 from 2002, and a lot of the spreadsheets seem to have something extra in the rows below the end of the data. Two examples: 1) I went to the bottom of the data in a spreadsheet and made a new entry.
|
| Changing formulas to values | 25 Mar 2008 09:36 GMT | 2 |
I have a spreadsheet that makes calculations based on the value of another cell (say, A1). If I change the value in A1, all the calculations are updated, however, I want certain cells to keep their values when saved, so that future changes to A1
|
| Printing | 25 Mar 2008 05:22 GMT | 2 |
Can I invert my text so that when I print on the back side the text both sides is faceing the same direction like a book?
|
| Not able to scroll in worksheet after performing filter | 25 Mar 2008 02:17 GMT | 2 |
There is a user on my network whose using Excel 2003 and when she preforms a filter in a particular worksheet inside a spreadsheet, she loses the ability to scroll up and down only, left to right is ok. This has happened in two separate .xls files and the way I get around
|
| im new and need help | 25 Mar 2008 01:02 GMT | 1 |
hi all hope everyones good i need some help with a project of mine and hoping this forum would be able to find it here for a gas bill calculator my spread sheet needs to do this.
|
| DEPENDENT DROP DOWN LIST | 25 Mar 2008 00:56 GMT | 1 |
From "Contexture.com", I was able to learn how to create a one dependent drop down list. However, I need to have 2 dependent list based on the first list. 1) My first list is of the department names 2) Each department has a list of capital expenditures, which I was able to name as ...
|
| What is an alternative to nested IF statements? | 24 Mar 2008 22:24 GMT | 1 |
Consider two rows of cells. The cells in the first row have names picked from a validation drop down list. I'd like each of the names to correspond to a specific number which needs to populate in the cell below the name. So if I pick cell A1 to be John, A2 should be 6. If I ...
|
| edit multiple hyperlinks | 24 Mar 2008 21:49 GMT | 7 |
I am working with Excel 2003... I have a excel file that is full of hyperlinks to numerous folders "job" folders within a single shared folder. The shared folder has been moved to a new file server.
|
| Need help with an excel macro to group values | 24 Mar 2008 20:59 GMT | 3 |
I am looking to group cells in excel. I have a column called level and the levels range from 4-6. 4 5
|
| Simple question | 24 Mar 2008 20:47 GMT | 4 |
I'm relatively new to Excel and I want to creat a sheet for my expenses where I can enter a number in one column and have it subtracted from the above cell in the next column and so on, all the way down. I can do this by clicking on the bottom left of the cell and
|
| from inventory to reduce stock record | 24 Mar 2008 19:45 GMT | 1 |
I have a basic stock order form with several items on it. How do I link it to master inventory on another sheet so that every time stock is taken it will automatically reduce. Appreciate as a novice I need to learn certain fuctions. Can anyone just get me started with where ...
|