| Thread | Last Post | Replies |
|
| condition sumif commands based on date range? | 23 Mar 2008 06:57 GMT | 2 |
How do I structure sumif commands based on a range of dates in an adjacent column?
|
| Split list via every other cell. | 23 Mar 2008 06:06 GMT | 7 |
Okay. I had someone show me what to do (on office 2003 I think) but I cannot get it to work on 2007. I have a list I am trying to split with every other number, odd and even. The list in column A is about 460 words. In column B, I was shown to do this....
|
| Excel - do not open workbook... | 23 Mar 2008 04:41 GMT | 1 |
The saved book opens, but nothing shows up. If I first open Excel and then open the saved book - then all sheets shows up with it's content. Why do I have to open Excel first on this pc? I have backed up the saved books and tried it on an another pc and
|
| Conditional Formatting | 23 Mar 2008 03:24 GMT | 3 |
Hi - can anyone help me to do the following... A1 = Sat A2 = Turn cell grey if A1=Sat. Thanks!
|
| VBA problem | 23 Mar 2008 03:19 GMT | 7 |
The code below works for one Workbook. Problem is, I copied the "Standings" and a "Master Sheet" to a new Workbook with a different name "Region 2". The NEW workbook keeps changing the Macro posted at the end of this VBA and nothing works. I can delete both VBA and Macro from ...
|
| Excel 2007 very slow to open or close | 23 Mar 2008 01:21 GMT | 3 |
I upgraded from office 2000 to 2007- bad idea- without any problems for the first months. Now, when I open or close EXCEL the CPU jumps to 50%+ and the Applications shows Excel not responding. After a minute or so , the CPU drops to normal and the program opens or closes. Why? ...
|
| HOW DO I GET AN X IN A CELL IN EXCEL TO COME & GO WHEN CLICKED | 23 Mar 2008 00:21 GMT | 3 |
i am trying to put a tick box into a spread sheet and have failed miserably, any info greatly appreciated
|
| Help with the script | 22 Mar 2008 23:36 GMT | 1 |
I have the following list. Date List 02-mar-2008 08459087671 02-mar-2008 08459087673
|
| Viewing Cell Data | 22 Mar 2008 23:29 GMT | 11 |
I just downloaded a Loan Amortization Schedule template. When I enter data in the cells, I can only see it if I highlight the cells. How do I make the data alway appear?
|
| Cell validation = format? | 22 Mar 2008 23:22 GMT | 2 |
I want to control the format of data entered into a cell to LNNNN LNNNN where L = Letter & N = Number (with a space between the two sets) Anyone any ideas how I can do this?
|
| Automation of data entry | 22 Mar 2008 20:30 GMT | 1 |
This is all fairly new to me so please be gentle...... i would like to know if there is a way to automate data entry between excel and access. Here is my situation, I have an Excel worksheet that figures money amounts over a selected period
|
| need help with mail merge from an excel file to word | 22 Mar 2008 19:58 GMT | 2 |
Help! I thought I could mail merge using my excel sheet into word but it's not workng. What am I doing wrong?
|
| sum every nth cell in a row | 22 Mar 2008 17:52 GMT | 5 |
Sorry Posted in wrong group earlier Hi I am trying to adapt Bob Phillips formula =SUMPRODUCT((B2:B32)*(MOD(ROW(B2:B32)-ROW(B2),n)+1=m))
|
| Trying to remove Blank Pages in 2008 | 22 Mar 2008 17:17 GMT | 1 |
i have created a three page spreadsheet but the spreadsheet now has 70+ pages. i am trying delete all but my first three pages. sorry for the duplicate question. My first Subject line was not clear.
|
| Why 8-Mar-08? | 22 Mar 2008 17:06 GMT | 7 |
Does anyone have any suggestions on date? When I type Mar-08 into any cell, the default day is 8-Mar-08. Does anyone know why the default day is 8? and how can I change the default day into 1?
|