| Thread | Last Post | Replies |
|
| formula question and issue | 07 Oct 2004 04:08 GMT | 7 |
When I type this formula in Excel it gives me the wrong amount. =SUM(H1257)*(5.25%)+(0.6)*1.27 - H1257 = $15.50 It gives me the answer to be $1.58 which is wrong. The clear answer is truly $1.79
|
| Passwords | 07 Oct 2004 02:53 GMT | 3 |
How can you crack password for Excel worksheet
|
| SumProduct/SUMIF? | 07 Oct 2004 02:12 GMT | 1 |
Awesome you RULE, It works great!!!!!!!! -- kkondrat -----------------------------------------------------------------------
|
| Troubles with Protection | 07 Oct 2004 01:22 GMT | 4 |
I have been asked to look into a strange problem on one of our workbooks. I threw everything I had at it and now would like to ask if anyone can offer any leads. Thanks in advance. Here is the problem: The workbook in question opens up as Shared (as stated in the title bar).
|
| excel cutting surname from name column pasting into new column | 07 Oct 2004 01:18 GMT | 1 |
I am taking an on-line training in Microsoft Office. One of the practice sessions is Working with a data file and fields. The program I am working in is Excel. I need to know how (very simply put) to cut an existing surname in a column and paste it into the next column. I ...
|
| Form with cells and TextBoxes...how to TAB to textboxes? | 06 Oct 2004 23:53 GMT | 2 |
I have a simple sheet that's being used as a questionnaire form. The sheet is Protected, only allowing users to select unlocked cells. Users tab from cell to cell and either type in or select an item from a list (Data/Validation). I also put in some textboxes but I can't tab into ...
|
| Deleting entire rows that contain a specific word | 06 Oct 2004 22:25 GMT | 3 |
How do I delete an entire row in excel that contains the word "construction"
|
| unexisted macro | 06 Oct 2004 22:03 GMT | 4 |
Hello experts... This has been driving me crasy!! I have this excel file which runs fine for the past few years on excel 97. It had no problem at all until I upgraded my office to 2003. Now, every
|
| Software of scripting to grab data from MS word file and fill in Excel fields? | 06 Oct 2004 21:54 GMT | 3 |
I have a 90 page financial report from MS word that I get each month. I would like to find a software package or scripting tool that will allow me to automate the process of grabbing #s from the ms word file and filling in fields in an excel file. I have a feel that there may
|
| VB script turns off NUMLOCK | 06 Oct 2004 21:50 GMT | 6 |
I am running a VB script which monitors changes on an Excel spreadsheet and sends out an email. After the script runs, my NUMLOCK is turned off. Why does it do this? Any ideas? Thanks,
|
| A macro question | 06 Oct 2004 21:40 GMT | 8 |
I have a macro that when prompted opens up many different files that are located in the same folder. Each of these files that I am opening are files that have been previously summarized through the use of a macro.
|
| Selecting last cell with a value in a list | 06 Oct 2004 21:27 GMT | 1 |
Using Xcel 97. very :confused: I am keeping a note of some stocks and shares of 25 different companie on the stock market. I have made a list of each day's finishing price Each day I add to the bottom of each list the current day's price (th
|
| Pivot Table by Multiple Consolidation | 06 Oct 2004 19:57 GMT | 3 |
I have a problem of creating pivot tables from multiplie consolidated ranges. The source comprises of 12 ranges, each of them is placed in a separate worksheets, named from "Jan" to "Dec".
|
| Calendar in Excel | 06 Oct 2004 19:25 GMT | 8 |
Can someone help me with a calendar to use in Excel that can be formatted so as to show special dates, current holidays, etc. WARNING: I need explicit instructions. This sort of stuff is not intuitive to me.
|
| Need advice to start off a project - HELP! | 06 Oct 2004 18:31 GMT | 1 |
Hello! I have never really used Excel much but I have had an idea which could make some of the work I do a lot easier. I know Excel is powerful but I don't know the best way to approach it so can anyone out there help me?
|