| Thread | Last Post | Replies |
|
| loop a list with the IF formula | 21 Jan 2008 22:10 GMT | 1 |
My list allows 30 names from A7:A36 (this list should be copied to row B, with a looping effect) But if not all 30 cells are filled in (may only have 10 voulunteers to do a job), how do I ust the formula IF the cell in the next row is empty, then
|
| Excel 2008 for Mac - Why no Print Preview function? | 21 Jan 2008 21:59 GMT | 1 |
PRINT PREVIEW has been dropped from Excel-08 for Mac, except for going all the way into the Print Menu. Or am I missing something? Even the Excel Help seems to confirm this. I use Preview frequently
|
| Vlookup question | 21 Jan 2008 21:53 GMT | 1 |
Hello. Per the extremely helpful advice of a contributor last week, I have created a table for a vlookup to reference. This table's range is -100 to 100 and each number within that range is accompanied by a color. For example, numbers 0 thru -100 are accompanied by green.
|
| How to enable Macros in excel 2007 | 21 Jan 2008 21:39 GMT | 1 |
Yesterday, in one of our deparments, we have installed Office 2007. Users are using some files created in Excel 2003. These files uses some macros created in that version it self. So, when they are trying to open these files in Excel 2007, it is araising them Security message. ...
|
| How can I convert numbers (ex. "4") to text (ex. "four") | 21 Jan 2008 21:36 GMT | 4 |
I need to convert some numbers into text. For example, I have a cell with a number "4", and I need to get a cell with a the text "four".
|
| Excel 2003 Add-ins | 21 Jan 2008 21:28 GMT | 2 |
I do not have my CD for my office product (within my immediate reach) and apparently the Add-in function for my excel product is not loaded onto my computer. Is it possible to download the add-in feature specifically for my statistics class from microsfts web site? I am ...
|
| excel invoice | 21 Jan 2008 21:20 GMT | 4 |
How do I change the logo in excel invoice?
|
| Data Validation 2003 | 21 Jan 2008 21:19 GMT | 7 |
I have created a list in column E which contains 3 values. If the use selects a value from this list, but the cell on column C is blank (also a list), I want to issue a warning to the user to tell them to put a value column C (which is also a list) before they can pick from the ...
|
| Skipping Import Text File dialog in a Macro | 21 Jan 2008 21:12 GMT | 5 |
I tried the following but the dialog always appears and forces me to click the Import button. Sheets("Sheet1").Select Application.DisplayAlerts = False
|
| goto function in macro 2 | 21 Jan 2008 20:33 GMT | 5 |
I probably didn't express myself enough, so I give it another try. Casus: sheet 1 cell A1 contains following: =sheet3!D19 I want to use GOTO (F5) with the contents of A1 to go to that cell
|
| share workbook/sheet | 21 Jan 2008 20:23 GMT | 6 |
I have a team of 8 people using a task list for daily opdate of status, work done, estimation to complete, etc.. The wordbook uses several sheets and macros. What I would like was if it where possible to make a little application that
|
| I need a formula... | 21 Jan 2008 20:17 GMT | 3 |
Here's the scenario - I have a file I use for sales forecasts, laid out as follows: Client Name - G6:G709 Product Name - UB5:AAM5 (12 groups of repeating names)
|
| Conditional Formatting | 21 Jan 2008 20:10 GMT | 1 |
Please POST response because email used is bogus to prevent spam: In my cells I have a formula and the formatted result in a percentage format. In my conditional formatting I have one condition if the cell value is
|
| Drop Down List from one worksheet to another | 21 Jan 2008 19:58 GMT | 5 |
I have data on a worksheet, alphabetized by a certain column. On another worksheet, I would like to be able to create a drop down list to choose one of these values. then have that value, plus other values show up on the worksheet.
|
| Why don't my filter results always appear on the bottom left? | 21 Jan 2008 19:37 GMT | 1 |
Sometimes when I do auto filter, the count or number of rows found in my search appear on the bottom left corner as filter results. Other times, even though I think I'm doing the same thing, the results don't show. How can I get them all the time?
|