| Thread | Last Post | Replies |
|
| Can anyone me help figure this out?? | 22 Aug 2007 23:26 GMT | 3 |
Here is my problem: I need to show how many days in a month a team member saw a customer. Each day a team member could see multiple customers. I just need the number of days per month he saw a customer. I have over 20 team members and thousands
|
| gridlines missing in web version | 22 Aug 2007 23:12 GMT | 1 |
I saved my excel spreadsheet as a web page and the gridlines were gone. I have "Gridlines" checked on the view tab of Tools->Options. Any suggestions would be appreciated.
|
| dumb macro question | 22 Aug 2007 22:58 GMT | 15 |
If I record a macro and save it in Personal macros, will it still work if I email the file to another person? I am going to make it that the macro works when they click a picture on the worksheet itself. What if I save the macro in that file and email it to someone....they will
|
| Auto Highlighting!! | 22 Aug 2007 22:41 GMT | 4 |
I use Excel to service appraisal reports.. pretty much have the info logged in with the due date of the report.. What I want to have happen is that when the report is late it will automaticlly highlight the whole row..
|
| Can anyone help me figure this out???? PLEASE???!!!??? | 22 Aug 2007 22:16 GMT | 3 |
Kind of hard to explain so I will try to set an example: Each time I type the word "abbey" into a cell, I would like for the next cell to populate with a monetary value I have assigned. Is this possible?? If someone could just give me a little guidance I could figure it out.
|
| Excel 2003 | 22 Aug 2007 22:14 GMT | 7 |
I have limited knowledge of Excel but I have a simple question. How do I apply a formula to an entire column? I want to enter a number into columns C and D and have it automatically multiply the numbers and insert it into column E. I figured out how to insert a formula into ...
|
| How to I sort titles alphabetically like in a library? | 22 Aug 2007 22:08 GMT | 16 |
I have a list of movie titles. Some start with "The" and "A". Is it possible to sort the list alphabetically (like in a library) without using those words as the primary words by which to sort? If so, how? Thanks,
|
| Add line with macro selected area | 22 Aug 2007 21:40 GMT | 2 |
For example I have a macro that sorts data from A1 to D5. Is there a way for this macro to pick up an extra line. Say I copied row 1, and then pasted it under row 1, so therefore, I would want the macro to sort from A1 to D6. Is there a way for the macro to automatically ...
|
| importing txt file help needed | 22 Aug 2007 21:10 GMT | 5 |
Hello. I have the following code (thanks to Ron de Bruin) and am trying to adapt it to my needs. What I have to do is to have the information go across the spreadsheet columns rather then straight down the worksheet. There are 4 columns of info, skip a column, then 4 more, and ...
|
| Active-X Controls - Transfer to Mac (excel) | 22 Aug 2007 21:08 GMT | 4 |
I'm blank... (can't remember).. but if I create a file on my PC with Active-X Command Buttons, with VBA code attached, will this run OK if I send to a MAC client/user? hummmmm..
|
| Opening Excel 2002 file in Excel 2003 | 22 Aug 2007 21:06 GMT | 1 |
I have a file containing array formulas for sum if. Whenever I update the cell it take too long to calculate in Excel 2002. or if i try to open it in Excel 2003 it took around 5-10 minutes to open the same file.
|
| CHANGE THE COLOR OF HIGHLIGHTING SELECTED TEXT | 22 Aug 2007 20:54 GMT | 1 |
In Excel 2007, can you change the color of the highlighing used to select text? It is very light and I can't really see what is highlighted
|
| Try to enter date; get ### | 22 Aug 2007 20:49 GMT | 8 |
I'm trying to enter a date in a cell for an attendance roster I'm making. I click a cell and enter "9/10." But, Excel converts it to "###" in the cell. The Formula Bar reads "9/10/2007." What is this ###?
|
| formatting picture | 22 Aug 2007 20:48 GMT | 1 |
I don't know if this can be done.... I currently have a spreadsheet with a couple dozen pictures inserted. I was wondering if there was a way to display only the picture name (ie picture.jpg) instead of the actual picture...for purposes of printing drafts.
|
| Manual vs. Automatic Calculation Speed | 22 Aug 2007 20:44 GMT | 7 |
I currently have a workbook that has several macros. One function I run copies and pastes special-values certain formulas, maybe 100-200 times, and also updates links to other workbooks. THe computer I run this on is a 64 bit processor, but it takes a minute or 2 to run the ...
|