| Thread | Last Post | Replies |
|
| VB problem | 17 Apr 2008 18:27 GMT | 5 |
I'm looking for a code that would do the following: - When I press whichever data entry validation key combination(((("Enter", "Ctrl+Enter", "Shift+Enter", "Tab" or "Shift+Tab")))) following data entry into a cell from either B or C columns, then if...
|
| Changing File Title Fonts | 17 Apr 2008 18:15 GMT | 3 |
Is there a way to change the Font or color on the title of a file or Folder?
|
| can I change font color for a date which is appoaching to act as | 17 Apr 2008 17:28 GMT | 1 |
I am using Excel and have added a date to a cell. I want to set up some form of alert on an impending date and wondered whether I could arrange for the date to change font colour "x" number of days before the date. Regards
|
| reinstall excel???? | 17 Apr 2008 17:16 GMT | 4 |
i accidentally uninstalled I think all my microsoft office 2003 applications(i can't access word or excel or open any files i receive from an email) is there a way to reinstall it, the program was on our computer when we bought it so we don't have a CD to reintsall it
|
| counting | 17 Apr 2008 17:12 GMT | 2 |
I'd like to know if you can count words inside of a cell that are separated by a comma. For example, if i have N,S inside of a cell, I'd want a count of 2. If i had NA,S - i would still want a count of 2. NA,S,C - i would want a count of 3. Please let me know if this is ...
|
| nested conditional query | 17 Apr 2008 17:04 GMT | 3 |
i have some work that i'm trying to sort and then subtotal like info. Column A Column B Column C acct # $$ subtotal what happens is that i get a check with 100 accounts, some duplicates
|
| checkbox | 17 Apr 2008 16:43 GMT | 1 |
I need to change the size of the physical checkbox itself. I found in propertis how to change from font size, background color etc... Any ideas?
|
| VBA question about selecting worksheets | 17 Apr 2008 16:39 GMT | 3 |
I am writting some code and i am stuck on how to select a worksheet. There is a month listed in cell A1 of Sheet1. It is a validated cell to select months. The rest of the Sheets are labeled named with months ie. January, February ... Based on what is in cell A1 on
|
| Filter to Duplicate Entries Only | 17 Apr 2008 16:38 GMT | 2 |
How can I setup a filter to show me only entries that appear more than once in a collumn?
|
| How do I allow a multiple selection from a dropdown? | 17 Apr 2008 16:34 GMT | 11 |
How do I allow a multiple selection from a dropdown? I know how to create a list / dropdown with multiple options but now the question is - how can I choose more than one option?? I know that usually it works by pressing CTR, scrolling down the list and choosing mulitple options. ...
|
| Hiding rows | 17 Apr 2008 16:27 GMT | 2 |
Wondering if there is a way to hide a row depending on the value of a certain cell. eg. if any cells in column C has "xxx" then hide entire row. I'm guessing there is a way to do it using logic or conditional formats but
|
| "minimize multiple excel workbooks on windows taskbar" | 17 Apr 2008 16:22 GMT | 4 |
I recently installed Internet Explorer 7 on my computer. Before installing it, I was able to have multiple workbooks open and when minimized they appeared on the windows taskbar. Now they are minimized in one workbook. Any ideas on how to minimize them again on the windows ...
|
| business hours formula help | 17 Apr 2008 16:08 GMT | 3 |
I have used this formula: =(NETWORKDAYS(D14,E14-1)*8+(MOD(E14,1)-MOD(D14,1))) to calc the time between start and stop considering an 8 hr business day. the problem is that i am getting a negative if the start and stop is in the
|
| How to avoide data conversion when opening a text file? | 17 Apr 2008 15:57 GMT | 18 |
I have a text file, in the first column I have dates in the format MM/DD/YYYY. When I open this file in Excel the first column looks bad: 8/31/2006 stays the way it is. 12/01/2006 is converted to 12-01-06 which is wrong - somehow Excel thinks
|
| Rounding up or down | 17 Apr 2008 15:51 GMT | 4 |
I am working on an excel spread sheet running price costing numbers. I want the numbers to round up to multiplies ending in 5 or 0. Example if I have a cost of $ 122.18, I need to round to 120.00 if the the number is 124.88 I need the number to round up 125.00.
|