| Thread | Last Post | Replies |
|
| Access to Excel | 15 Jun 2007 21:26 GMT | 3 |
I need to get a table from MS Access into MS Excel in Office 2003, any suggestions
|
| FIND IF => | 15 Jun 2007 21:21 GMT | 5 |
Good morning, I have a document I need help on. A B C D E 1 5
|
| Excel file will not import to Access, what may be the cause | 15 Jun 2007 21:19 GMT | 1 |
Creating an Access data base to which many excel files have been imported, some with errors, somewith out. One excel file in particular will not import. What may be the cause, what may I look for
|
| Is it possible to use variables in Excel? | 15 Jun 2007 21:19 GMT | 2 |
Right, this is quite hard to describe, but I'll have a go. I am trying to find a satisfactory way of making a football (soccer) ranking spreadsheet using Excel without having to resort to too much programming. I have a large collection of international results (over 32,000 and ...
|
| How to retrieve multiple values in multiple rows with one criteria | 15 Jun 2007 20:57 GMT | 2 |
Can anyone please help me with this question. I would like to type a code in a cell and would like to extract all the rows with that code. Is this possible or do I need VBA or is there a formula that can do this? Thanks
|
| CODE PROBLEM | 15 Jun 2007 20:07 GMT | 2 |
Help appreciated I have the following code: Private Sub ComboBox1_Change() With Me.ComboBox1.TopLeftCell
|
| Using cell color as criteria | 15 Jun 2007 19:54 GMT | 6 |
Hi, I'd like to write a formula with IF function, using a cell color as a criteria. Is this possible? Like, =IF([cell.fill.color]=red,[dothis],[dothat])
|
| Formatting time from imported data | 15 Jun 2007 19:52 GMT | 3 |
Hello everyday I import data that looks like this ACD Time 8:52:40
:20:26 |
| quick access toolbar | 15 Jun 2007 19:51 GMT | 1 |
Can the Quick Access Toolbar in Office 2007 (example Excel) be copied from one instance of Office 2007 to another machine's copy of Office 2007?
|
| Macro Help | 15 Jun 2007 19:50 GMT | 2 |
How do I write a macro to tell a cell not to perform the calculation in it if one of the cells in the calculation is empty? In other words, "Don't do C5-B5 if C5 is null"
|
| HELP!!!!!!!! | 15 Jun 2007 19:44 GMT | 3 |
How do I exclude empty cells when trying to average columns? I am doing a large sheet of date differences and want to exclude any empty cells from the calculations.
|
| Calender does not desapear | 15 Jun 2007 19:33 GMT | 9 |
I inserted a calender option in the cell "C12". It is working very good, however, the calender does not desapear it is there all the time. I just want the calender to appear when the cell "C12" is selected. Also, I would like to calender desapear as soon the date is selected ...
|
| Getting rid of thousands of rows Excel 2002 | 15 Jun 2007 18:41 GMT | 3 |
I have an excel 2002 spreadsheet set up by someone else which contains thousands (likely the max) of rows. I am trying to merge into word using this sheet and it takes forever and causes problems editing the merge. How can I remove the extra rows? I have seen suggestions to ...
|
| numbering | 15 Jun 2007 18:38 GMT | 1 |
How do I keep number pass the first page, is their a formula for that function?
|
| Equal = both value and format of another cell | 15 Jun 2007 18:37 GMT | 3 |
How can I modify the formula of equals (=) so that it equals both the value and formatting of another cell?
 Signature KBC
|