| Thread | Last Post | Replies |
|
| Protecting a watermark? | 23 Aug 2007 21:25 GMT | 2 |
Is there a way to protect a watermark in excel?
|
| syntax error - help | 23 Aug 2007 21:08 GMT | 2 |
Worksheets("Cost Analysis").Activate Set UdRng = ActiveSheet.Range("F10:F38") UdRng.Formula = "=IF(AND(A10>0, H10>0),"EQ","")" << occuring here ActiveSheet.Range("A9:G38").Select
|
| Numeric Format Changes From 1 Cell to the Next? | 23 Aug 2007 20:38 GMT | 2 |
I have a client with a list of numbers, all 15 digits long, in one column. All cells are formatted as numeric "General". All cells display all 15 digits, except one. This one cell displays the number in scientific notation, even though the cell appears to be formatted as ...
|
| Second small arrow on filter button | 23 Aug 2007 20:28 GMT | 1 |
In Excel 2007, one of our users noticed a small, black arrow on the filter button in her spreadsheet. It appears to the right of the filter or standard arrow on the button and it's a skinny black arrow pointing up. What is this and what does it mean/do?
|
| Protecting header and footer? | 23 Aug 2007 20:24 GMT | 1 |
Is there a way to protect the header and footer in an excel file? I have the sheet protected but it still allows you to change the footer that I currently have.
|
| Sum VLOOKUP | 23 Aug 2007 20:14 GMT | 2 |
I'm using the following formula to lookup up my employees based on their ID# and return the value in column 2 where a match is found. How do I sum up these matches if the employee number appears more than once? =VLOOKUP(X2,'LaborDetail'!P2:Q1000,2,FALSE)
|
| Locking Info only which came from another worksheet | 23 Aug 2007 19:58 GMT | 1 |
I have an excel 2003 File (Workbook) with several worksheets. Some info in the worksheet that I want to preserve is derived from the other worksheets. I want to retain the actual values in the main worksheet and delete the other worksheets. Is there a way of doing this without ...
|
| I have 2 books and i have to vinculate both what can i do | 23 Aug 2007 19:54 GMT | 1 |
When I sort the fon I miss the vincles. If yo can answer me in Spanish that better
|
| Mail merge an excel cell that is preceeded by an apostrophe? | 23 Aug 2007 19:50 GMT | 1 |
How do I merge an excel spreadsheet into a Word document when it includes cells that are formatted as text or preceeded by an apostrophe?
|
| Need help with formula | 23 Aug 2007 19:42 GMT | 2 |
I need a formula that will subtract 10% of a number.
|
| SUMIF does not work with blank cells | 23 Aug 2007 19:36 GMT | 3 |
Can SUMIF be used if there are blank cells in the range of data? (The worksheet has been formatted for a purpose, so I do not want to remove any of the blank cells.)
|
| Time Difference | 23 Aug 2007 19:32 GMT | 1 |
Tried everything on this, I have two times in a spreadsheet.One is 05:15 and the other is 08:17. I need the exact difference between the two in hours to three decimal places at least, so here it should show 3.033, instead all it ever shows is 3.00. I've tried the hours function ...
|
| Newbie Macro Question | 23 Aug 2007 19:15 GMT | 1 |
I am tasked with data entry. From a spreadsheet, I enter data into Access. To keep track of what I've entered from the spreadsheet, I'd like to change the color of a cell. So, I'd like to have a quick little macro that colors the current cell that I am in to a different color. ...
|
| Sumproduct with OR | 23 Aug 2007 18:24 GMT | 4 |
I searched through some of the questions here to find a solution to this, however, i'm more confused!! I would like to return a total where one of the columns i'm totalling has more than one criteria. Specifically in this formula i would like to total
|
| Clear Auto Filter on Close (or open) | 23 Aug 2007 18:16 GMT | 3 |
How would I ensure that if Auto Filter is on, it is cleared when the workbook is closed (or opened)? I'm not much of a programmer, but I can copy and paste! :) TIA
|