| Thread | Last Post | Replies |
|
| Excel xp is protecting my worksheet so I cant modify them anymore. | 01 Apr 2004 14:49 GMT | 6 |
I have a worksheet from my company for my monthly expenses. In the past I would take the sheet from the previous month, modify it, save it /renaming to the new month, print and mail it in. now, my computer has been baselined from 2000 to XP, with office XP.
|
| Paste Special automatically | 01 Apr 2004 13:19 GMT | 9 |
I was wondering if the following is possible: Cell A1 = has a formula that changes with time Cell B1 = can be blank or have an X I would like to setup someway that Cell A1 stops calculating (saves the last
|
| invoicing template | 01 Apr 2004 12:11 GMT | 3 |
I've created an invoicing template which lists all the items that we sell and the number the customer has ordered. It's used everyday and then is saved under that day's date so each time the invoice template is opened, it's empty. What I'm now looking to do is create a separate ...
|
| Copying Excel data to a .txt file | 01 Apr 2004 09:35 GMT | 4 |
Hi, I am trying to copy an excel file to a .txt ! My excel file has o column and in each cell there are allot of data seperated by "," (eg 34555,aaa,r34rr, .....). When I try to transfer the excel info to
|
| MAcros big Q! | 01 Apr 2004 09:16 GMT | 3 |
i got a Q, i know pretty much about using the formulas in excel, but still too rookie using macros, so i got a Q about it. i made a macro, the result is a graphic char, when i record the macro i folow all the steps to create the char, and specify the chart has to be
|
| Import .qif file into Excel | 01 Apr 2004 07:32 GMT | 1 |
How do I do that? I can only get it to open in a flat file, one cell per row. Obviously not working.
|
| Consolidate Workbook | 01 Apr 2004 06:58 GMT | 2 |
I am using Excel 2000. I am trying to consolidate 2 workbooks into one. I want to browse and find my two workbooks. What is the procedure? Thanks Douglas
|
| excel data gathering | 01 Apr 2004 06:48 GMT | 2 |
I have a spreadsheet that has columns for tracking information. I am trying to track spending for the week. When the weekending date is input. I need to pull from 3 columns. Date, code, and amount based on the previous 7 days of the week ending date. I have racked my brain
|
| How to create drop down list? | 01 Apr 2004 06:42 GMT | 4 |
How do I create a cell such that the user has to select from one of selections in a drop-down list? For example, column A is called "Contract Length" In each of the cell of column A, I'd like the user to select from only 3 choices: 12, 24
|
| A bit OT | 01 Apr 2004 06:19 GMT | 8 |
I am a classroom trainer for beginner and intermediate level end users on Excel (and other MS packages). I have a student that is asking for one on one training at her home and I have no idea what to charge her for that. Has any body ever done such a thing?
|
| How to create drop down list? | 01 Apr 2004 05:52 GMT | 1 |
How do I create a cell such that the user has to select from one of selections in a drop-down list? For example, column A is called "Contract Length" In each of the cell of column A, I'd like the user to select from only 3 choices: 12, 24
|
| Assistance Requested | 01 Apr 2004 04:56 GMT | 2 |
Ok I am using Excel 2000. Here is my problem. I have a large text based database that is divided with Tabs. When I open the document in Excel, however, though I am able to highlight the text as though it were in columns - which I want to do in order manipulate the text, I cannot ...
|
| Use a non-contiguous range of numbers for data validation | 01 Apr 2004 03:31 GMT | 5 |
Is it possible to use a non-contiguous range of numbers with Excel's built-in data validation, or is this something else that needs to go in the Worksheet_Change event? TIA, Rick
|
| Outlook express spelling failure | 01 Apr 2004 01:15 GMT | 2 |
Can anyone help me how to get Outlook Expess spelling function to work. Everytime I try spelling an error message appear which would not allow spelling check. I've attemped various reinstallations of Outlook but to no avail.
|
| Sorting mixed data | 01 Apr 2004 01:03 GMT | 2 |
From Excel 2000 Help.... ------------------- Check that mixed data is formatted as text If the column you want to sort contains both numbers and numbers that include text characters
|