| Thread | Last Post | Replies |
|
| Format excel sheet where one row is silver and the next white ??? | 16 Dec 2004 21:46 GMT | 5 |
I have an excel sheet where it is formatted that one row has a silver background and the next has a white background .... How is it done ????
|
| Newbie question | 16 Dec 2004 21:30 GMT | 5 |
Please help, I'm a total Excel newbie. I need to create a spreadsheet that works pretty much like a checkbook register. I need to be able to make daily entries of deposits and withdrawals (dollar amounts) and keep a running balance. I don't want the balance column to extend all ...
|
| Moving cursor to next open cell | 16 Dec 2004 21:00 GMT | 3 |
What command do I need to type to move the cursor one cell down? I have created a macro that copies an entire line of data to a spreadsheet by going to a specific column, using the end and down commands, to find the first empty cell. My problem is that after I have recorded the ...
|
| Averaging columns | 16 Dec 2004 20:15 GMT | 3 |
I made a spreadsheet where data can be entered into 8 columns. In eac column for each day, this data has a formula run on i (=(E16-E$15)/E$15, for example). Then sum of these calculations ar taken and averaged (=SUM(C17:J17)/8). The problem is, towards th
|
| Splitting a Cell | 16 Dec 2004 18:46 GMT | 2 |
I have a Cell that contains first and last name data. I would like to split this one cell into two cells, one with first name data and one with last name data. I have tried doing this through a Macro, but with no sucess. Can anyone point me in the right direction? Thank you!
|
| ???: Freezing data at a set time | 16 Dec 2004 18:20 GMT | 2 |
I am ingesting real-time temperature data into excel. I want to know what the temperature was at certain times of the day. How do I get the computer to save the temperature every hour but also keep importing and monitoring the current temperature ?
|
| Securing Workbooks | 16 Dec 2004 18:03 GMT | 1 |
Gang: I would like to secure my Excel 97 (and Excel 2000) workbook from users in such a way that they can only enter values in a specific range and view the results in another range. I'd like to keep my formulas and other sheets
|
| VB Scripting/Macro - Filling/Editing Worksheet References | 16 Dec 2004 17:55 GMT | 2 |
Question: What VB code will allow me to rewrite just the worksheet reference in a function/cell reference. For example it says =January!$AH40
|
| how to stop program in a big loop | 16 Dec 2004 16:17 GMT | 3 |
Hi, everyone Right now I wanna do a time-comsuming loop in excel programming, for example: for i = 0 to 100000
|
| Hide too long text in a cell | 16 Dec 2004 16:17 GMT | 2 |
How can I hide the part of the text that is too long for the cell? This automaticly happens when in the cell on the right is already a text. But I want this also when there is no text in the neighbouring cell. (Note: I don't want to use wrap text)
|
| Using on one list derive from another | 16 Dec 2004 06:26 GMT | 5 |
I need to write a formula to operate on numeric values from column B in the contiguous range of all rows where column A has a specific string value. Column A is sorted on that string value, ascending. I'm using Excel from Office Pro 2000.
|
| time-sheet record with over 24 hours | 16 Dec 2004 06:24 GMT | 2 |
I want ot create a time sheet for my employees where I can have the first column be the start time, and the second be the end time, with the ability to start at 10pm and finish the shift at 8am, which is over the 24 hour mark. Then have the hours totalled in the third column, ...
|
| Making sound with Excel | 16 Dec 2004 06:06 GMT | 2 |
Can Excel make sound ? I am ingesting real-time data into excel. When certain criteria are met, I want the computer to ring an alarm or play a sound file. How can I do this?
|
| Calculation order | 16 Dec 2004 05:36 GMT | 2 |
What order do calculations calculate in? Are the first calculations created in the worksheet always calculated first? If the calculations are in row 1, are they calculated from left to right? If the calculations are in column 1, are they calculated from top to bottom?
|
| Fix the order of the last name and first name | 16 Dec 2004 05:29 GMT | 8 |
How do I fix the order of the names, when the last name is first and the first name is second, separated by a comma.
|