| Thread | Last Post | Replies |
|
| Importing-Exporting | 30 May 2006 21:15 GMT | 2 |
I ahve been trying to import a list of contacts from an excel file to Outlook.but Ikeep getting an error. the error msg is a Translation error. I would appreciate any help or advise.
|
| Pulling data from a list | 30 May 2006 19:49 GMT | 4 |
Tough problem. I have a list of 40 records in one column, each with different data, but with the same field headings (100, 245, 260, etc.) that looks something like this: 100 Joe Smith
|
| Excel fill handle copying does not copy formulas | 30 May 2006 19:01 GMT | 3 |
My Excel has suddenly taken to ignoring the usual rules for the fill handle, and now will only copy the values of the first cell when dragged, instead of copying 'all' including formulas. I have explored all the possible settings, and they seem to be as they should be. I have ...
|
| calculating earned leave | 30 May 2006 18:52 GMT | 8 |
Our employees earn leave at a percentage of their hours worked. This is simple enough to set up. If they work 80 hours in a pay period and earn at the rate of 5%then the formula is simple. However, the spreadsheet tracks only leave (leave clerks are the only users). Currently ...
|
| Why Indeed | 30 May 2006 18:31 GMT | 4 |
I am amazed that so many people, some of whom I happen to know are highly intelligent, have wasted time sparring with a drooling idiot like this Aaron person about why we use Excel. Excel has conquered the world, period. Obviously Aaron doesn't understand it and feels left
|
| how do I open an excel spreadsheet attachment from microsoft word? | 30 May 2006 17:37 GMT | 3 |
I received an email with an attachment that is an excel spreadsheet. My computer is coming up with a message to get program from online. I go to the website and click on microsoft excel and download, but I still can not open the attachment. What am I doing wrong, and how do I ...
|
| How to avoid name conflicts while copying sheets | 30 May 2006 17:16 GMT | 1 |
i'm writing macros for an excel file. i've a macro which will read the data from there are 30 to 40 work books each work book contains 8 worksheets and copies that data and paste the copied data into new workbook with corresponding 8 sheets.
|
| How can I visually display slope in an excel chart? | 30 May 2006 17:11 GMT | 3 |
Hi I'm new to excel charts and can't figure out how to display slope visually rather than by default scaling of y-axis.
|
| Printing based on Conditional Formatting! | 30 May 2006 17:09 GMT | 4 |
Is it possible to have a macro be able to print based on conditional formatting? I have a base sheet that has several cells with buttons on so that when a certain button is selected you are directed to the sheet required.
|
| Unprotect a worksheet | 30 May 2006 17:06 GMT | 2 |
I've been given a excel workheet by a colleague, but I need to make changes, but the worksheet has a password on it, how do i get around this.
|
| Does Custom Autofiltering dates work in XML Lists? | 30 May 2006 16:08 GMT | 3 |
I downloaded some reporting in XML format because it was the easiest. Now i am trying to use the autofilter to custom filter dates however it won't work! For instance, i'm trying to custom filter by:
|
| Time Calculation | 30 May 2006 16:01 GMT | 11 |
Is it possible to set up a Time Calc as below? A1= 10:30AM A2=10:35AM A3=10:40AM
|
| limiting number of characters in a cell | 30 May 2006 15:48 GMT | 2 |
I am trying to create a mailing list sorted by zip codes. The file I am working with has zip codes in the "plus 4" format and I need to limit the zip codes in a column to just the basic 5 zip code numbers. For example, I need to limit zip code 123456789 to just number 12345. Any ...
|
| Help displayed while hovering over a button | 30 May 2006 13:18 GMT | 1 |
I need to have help display in my spreadsheet while the user is hovering over a custom button. Much like a cell comment but on buttons, any ideas? Thanks
|
| how to compare 2 worksheets in 1 workbook | 30 May 2006 12:40 GMT | 2 |
I'm trying to figure out how to find any difference in 2 (or more) worksheets in one workbook (file). These are text files.
|