| Thread | Last Post | Replies |
|
| Help | 07 Dec 2006 00:25 GMT | 2 |
I need to make a spreadsheet that will keep track of my inventory. I want to be able to have a list of all my inventory with the total I have in stock. I then want to have each cell have a formula that calculates if I have dropped below a set min or above a set max.
|
| Tools > Add-Ins when multiple worksheets selected | 06 Dec 2006 22:20 GMT | 1 |
I just noticed this in Excel 2003. When multiple worksheets are selected (grouped), the Tools menu shows Add-Ins... disabled. No obvious reason for that that I can think up.
|
| predictions | 06 Dec 2006 21:41 GMT | 6 |
I have collected all my wife's orgasms in a workbook. every orgasm has a date attached. Now, can I with some formula predict the next orgasm? Any help is greatly appreciated.
|
| Auto Rename Sheets in an existing Workbook | 06 Dec 2006 21:01 GMT | 1 |
1. I would like to know if i can Auto name the sheet name.?? 2. Also more if i would want to make changes to a workbook, can seperate sheet be created in the same existing workbook? Plz Help.
|
| Edit SQL Command in Mail Merge | 06 Dec 2006 20:57 GMT | 1 |
How can I edit the SQL command to filter recipients in a mail merge using Excel as the Data Source. Thanks,
|
| Data validation based on another cell | 06 Dec 2006 20:02 GMT | 2 |
Im not quite sure what to put in the title, but heres my problem: I want prevent people from inputing into a cell if other cells have been filled in. A1 has no value
|
| Counting with spaces | 06 Dec 2006 20:01 GMT | 1 |
How do I count a total of things with spaces inbetween? EX: 4/3/01 6 4/4/01 7
|
| Merging into an Excel Cell the content of the Bookmarked table Cell from msword | 06 Dec 2006 18:32 GMT | 1 |
Your help will be appreciated. I am looking at finding a way to use a link from an Excel Cell that will pickup a value entered in a bookmarked table cell in msword. I hope that my question is sufficiently clear.
|
| version excel | 06 Dec 2006 16:47 GMT | 1 |
bonjour a tous, & a tous les pro bien sur es qu'il est possible ,que des l'instant on modifie le code VBA EXCEL on incremente un compteur pour les mise a jour cela me semble plus simple merci pour vos reponse
|
| Separate Button for Auto Filter Selected Range | 06 Dec 2006 15:15 GMT | 2 |
How can we creat separate button in MS excel for selected range class in auto filter. If we click on button then only selected range class appears. Should we write script on Macro in VB. For example, Button Name "XYZ" Column A (with Auto Filter)
|
| Entering Multiple Items in a Single Cell - gmail has it right, can Excel do it too? | 06 Dec 2006 15:09 GMT | 1 |
In gmail, when I click 'Compose Mail' the cursor is placed in the 'To:' textbox. The behavior that takes place in this textbox is what i'd like to achieve in Excel. When I begin to type a contact name, a smart dropdown list presents all the contacts that begin with the text ...
|
| Evenly, yet randomly, distributing cells | 06 Dec 2006 04:12 GMT | 2 |
I'm trying to design a neuroimaging task in which I have 6 runs of 8 trials (2 presentations of 4 stimuli: A,B,C,D) each. I'm setting up my design matrix using excel, with runs in six columns and trials in eight rows.
|
| Auto-execute an Excel macro upon opening .xls file | 06 Dec 2006 00:42 GMT | 2 |
Ok, now that I've got my default template set, with a macro module, I'm trying to set a macro to auto-fire upon opening. Here's the macro: /¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
|
| Default template management problem | 06 Dec 2006 00:38 GMT | 6 |
I'm new to Excel, '03. I've set up a default template, book.xlt, in the xlstart folder, and excel is reading it properly. Now I want to add some macros. Problem is, when I open the VB editor, Insert a Module, then try to save it, the VB editor
|
| Dates not copying correctly | 05 Dec 2006 21:54 GMT | 4 |
I have a problem copying a column filled with dates from one sheet to another. The dates are off by four years less a day when I copy them into a column in a new spreadsheet. Does anyone know why this might be?
|