| Thread | Last Post | Replies |
|
| Import Data | 28 Feb 2006 17:20 GMT | 1 |
When I'm trying to import from an external data source via (Data--> Import External Data--> Import Data.) I have to navigate for the data sources. I was wondering if there was a way to make excel default to a directory other than the "My Data Sources" directory? Can this be edited ...
|
| looking for Excel VBA work | 28 Feb 2006 16:21 GMT | 1 |
I am looking for Excel VBA work... I have been working with excel and vba for the past 3 years. I am very involved in it. I love helping people. Although I do require some money for my work, I do not charge as high as most programmer's do. If you need some help or some work
|
| stubborn cell format | 28 Feb 2006 16:10 GMT | 5 |
I have two workbooks containing billing data on phone numbers used by my employer (about 2,600 lines of data in each book). I'm trying to compare the billing data by copying the relevant rows and columns from each workbook into a third, new workbook, and then sorting the data by
|
| Access/Excel: Create multiple Lines/Column out of one mulit-line Column? | 28 Feb 2006 16:06 GMT | 2 |
Hallo everyone! I spent a lot of time today searching for a response to my question but I had unfortunately no success. The problem is the following:
|
| Excel true date formulas | 28 Feb 2006 15:58 GMT | 2 |
I need to know how I can enter a date , 02/28/06 in one cell and then i another cell tell me if that date is true. It is to be used when there is a list of contracts, in one cell th date of expiry, and them another cell if that date has come to pass o
|
| autofilter record count | 28 Feb 2006 15:52 GMT | 1 |
When using the Autofilter function, the bottom of the worksheet display the recounts count (xx of xxx records found). somehow I lost thi feature. Is there anyway to get it back --
|
| Paste Special: set text default?? | 28 Feb 2006 15:29 GMT | 9 |
Is it possible to set the default for the Paste command to 'Paste Text"? I am copying some text from webpages, and the only way I can put it into a spreadsheet without copying all the formatting, is to use Paste Special: Text. I would like to make this the default for Paste, so ...
|
| Macros setup deployment | 28 Feb 2006 14:39 GMT | 5 |
I have a Template (to place in the template folder) and a .xls file with macros (to place in the XLStart folder) to deploy. Is it possible to deploy thoses files with a setup.bat? The difficuly is to get the template and the XLStart folders in a command line.
|
| Grouping in Protect WorkSheets | 28 Feb 2006 12:20 GMT | 1 |
I need to be able to interact with the Grouping Function (Data - Grou and Outline - Group ) while the worksheet I am working on is protected Is this possible --
|
| dates | 28 Feb 2006 10:53 GMT | 3 |
dob 22/07/1975 today 28 February 2006 term to age 60 _______ term to age 65 _______
|
| Acceleration question. | 28 Feb 2006 06:53 GMT | 2 |
I have a data serial. its seem has a accelerate factor. 1.012295082 2.766393443 4.887295082 7.12295082 9.631147541 13.06762295 I try counting a/b, b/c,... got this result.
|
| Getting rid of the date | 28 Feb 2006 06:02 GMT | 5 |
I'm trying to get rid of the date, it is already on another part of th spreadsheet. The problem is that everytime I enter a set of number such as 2/2 or 2-2 the date will appear. How do I get rid of this --
|
| editing and printing comments | 28 Feb 2006 03:26 GMT | 1 |
I have a spreadsheet and I've added comments to some cells where I can add details pertaining to that specific cell. Is there a way to make edits to the cell easy...i.e. using a hotkey or perhaps another method instead of using a comment. Also, I want to be able to print the ...
|
| Cannot Format | 28 Feb 2006 01:45 GMT | 2 |
I copied a column of figures from a site to my excel file. Now when I try to add the columns figure it just shows zero. When I went to format box it was showing general - so I changed it to number. Still no change.
|
| Payroll | 28 Feb 2006 01:35 GMT | 6 |
I've been working on a payroll workbook, and most everything is working the way I want it to except the YTD totals. I want to update the YTD cell with the push of a button (or keystrokes) after the user finishes with the rest of the values. Help?
|