| Thread | Last Post | Replies |
|
| Can an excel XP 2003 file be exported to an Access mdb file if so how? | 22 Oct 2004 08:18 GMT | 1 |
Greetings All, I have and app that will only read Access mdb files but I don't have access to "Access" is there a plugin or will excel 2003 xp save directly to an Access 2003 file format? Is there a free plugin around?
|
| Count values in Cells Accross | 22 Oct 2004 08:18 GMT | 1 |
I want to calculate the values in cell A1 across. Eg. Cell A1 has a value of 36. I want to calculate the values across in the 36 non blank cells located in the same worksheet. Any help appreciated.
|
| Sorting a column by using formula | 22 Oct 2004 08:17 GMT | 2 |
Can i sort a column range by using any formula -- Prais -----------------------------------------------------------------------
|
| Count Values in same worksheet - Urgent please | 22 Oct 2004 08:09 GMT | 1 |
I have a number in cell E14. (Eg36) I need to sum values in the next non blank 36 cells starting from cell Q14. The result from the above should be cell D14. Please help.
|
| Sorting a column by using formula | 22 Oct 2004 07:40 GMT | 1 |
my sheet goes like this Cell A1: Mr. abc Cell A2: Mr. XYZ Cell A3: Blank Cell
|
| how do i locate student data files in excell | 22 Oct 2004 07:39 GMT | 1 |
I am a student trying to use microsoft office xp for students and teachers, I am having trouble finding the storage location of the student data files.
|
| Custom filters | 22 Oct 2004 05:51 GMT | 2 |
I created a custom filter on a city field, looking for all cities that start with So. The criteria used was begins with SO. THis works fine. I then tried to filter for zipcodes begins with 46. THis
|
| Control + End | 22 Oct 2004 02:34 GMT | 2 |
I frequently start with a large spreadsheet, filter out many of th rows, and end up with a smaller spreadsheet that I will work on for month. I like to use "control + end" to go to the last cell in th sheet, however, it now takes me to the last cell of the original sheet
|
| Using Media Player to play hyperlink sounds | 22 Oct 2004 02:26 GMT | 1 |
I'm putting together a sound document that has hyperlinks to sounds o the server. At the moment, clicking on a link will play the sound i Excel but no sound controls such as stop, pause etc appear. How can get Excel to use Media Player to play the hyperlink sounds
|
| Mail-merge from Excel drops records | 22 Oct 2004 02:00 GMT | 1 |
Using Excel 2000 and Word XP or 97, all even numbered rows from the Excel worksheet are dropped from the merge-to document even though I specify Merge All Records. This is independent of the contents of the rows, because sorting to a different sequence changes which rows are ...
|
| Tab create option barred | 21 Oct 2004 23:21 GMT | 2 |
I am right clicking on one of my tabs to get access to the menu t create another tab, but my file does not want to give me access to it how do I fix that? Regard
|
| sorting data | 21 Oct 2004 23:11 GMT | 5 |
I have a particular sorting requirement I need help with. The spread sheet is very simple, basically an inventory file with columns representing the following data: Column A: five digit product number
|
| NAMED Custom Number Format | 21 Oct 2004 22:55 GMT | 3 |
Is there any way of giving a custom number format a name, so that it appears in the list of types when you bring up the custom number format dialog? We use the same format all the time (comma separated, no decimals), & I'd like to create this, call it Separated Ints (or
|
| Audits | 21 Oct 2004 21:07 GMT | 2 |
I am using Excel 2000 and am a beginner. We are going to be doing some QI testing for our department in our hospital. We will be looking at tracking a few things. The most important is to track which therapists take the most time to start treatments and also get a general idea ...
|
| Help: Need macro to copy rows to different workbooks | 21 Oct 2004 20:36 GMT | 7 |
I am very new to writting macros and really need help. On my master worksheet I have about 100 rows with information on different customers. I would like to copy information for each customer to a different worksheet
|