| Thread | Last Post | Replies |
|
| how to reference a cell on one page to a cell on another page | 19 Aug 2007 22:10 GMT | 2 |
i would like to make a worksheet with seven pages one for each day of the week. in a1 on the first page put the date. then have each page automatically insert the date on that day.
|
| extract from multiple workbooks in a folder | 19 Aug 2007 21:57 GMT | 8 |
I have one folder that contains several workbooks. They are contracts and have been saved to this folder based on their scheduled date for the work to be completed. (master!u3) Their names will be random. (Customer names last name, first name) I would like to extract the value ...
|
| How do I assign a fixed number value to text? | 19 Aug 2007 21:43 GMT | 5 |
So when the text is selected, there is an underlying value that can be totaled, for example. Thanks.
|
| how do I add text in the same cell with a fomula? | 19 Aug 2007 21:13 GMT | 12 |
I want to add a footnote reference (*) in the same cell with a formula. I want the cell formula results to look this. 368 * Thanks,
|
| Autofilter versus List | 19 Aug 2007 21:09 GMT | 1 |
What is the difference between the 'Autofilter' and 'List' functions found under the Data drop-down menu?
|
| Excel Histogram | 19 Aug 2007 20:33 GMT | 1 |
The bins are upper class limits, but they are displayed at the beginning of the class, not the end, which is misleading. Fussed with Format Axis but could not get it to move the bin labels to the right, only up and down (useless). Any ideas? Thanks.
|
| Macro Security to "Low" | 19 Aug 2007 19:59 GMT | 7 |
I have a lot of Excel files with macro inside. Is it possible to set the level of Macro Security to "Low" once and for all (Excel 2002 SP3) ? Thanks in advance. Regards,
|
| Help with formula please | 19 Aug 2007 19:52 GMT | 5 |
A B C D E 03/27/2007 11:49 03/27/2007 16:47 True 03/27/2007 21:30 03/27/2007 20:00 False I'm trying to find out the formula for column E.
|
| Excel to Outlook | 19 Aug 2007 18:20 GMT | 5 |
In order to import addresses to outlook contacts from an excel spreadsheet does it have to be saved in a .csv file? Wont an .xls work? I am just wondering since I am trying to explain how to do this to a client. I have prepared a spreadsheet of all our her contacts and she ...
|
| minutes calculation formula | 19 Aug 2007 18:08 GMT | 3 |
A B C D E DateArriv TimeArriv DateDepart TimeDepart Total Minutes 8/8/2007 14:30 8/8/2007 14:45
|
| nested formulas in excel | 19 Aug 2007 16:54 GMT | 3 |
Have a worksheet where I am tracking payments which may be made in full or may be made in two installments. I have written a very simple formula which subtracts the values in two columns (installments) from the total due column, however, when individuals pay in two installments, ...
|
| How to run macro with scheduler | 19 Aug 2007 16:46 GMT | 4 |
What is the best way to run an excel macro with the scheduler?? - is it possible to run the macro on file open?? how - is it possible to run directly the macro as a VBA file?? - maybee another way??
|
| play sound when pressing commandbutton | 19 Aug 2007 16:12 GMT | 1 |
How can I play a sound when I press a commandbutton
 Signature Hoyos
|
| save file notification | 19 Aug 2007 15:52 GMT | 4 |
How to skip the: "Do you you want to save changes you nade to....." notification?? (files which are read only for all usesr) thanks
|
| Finding Corresponding Cell Value | 19 Aug 2007 15:49 GMT | 2 |
In Worksheet 1 > Column A has a list of 1000 different names. For example, cell A750 = "Ralph". Column B has a corresponding number to the values in column A. For example, cell B750 = "55". Column Y has a list of names which change dynamically. Column Z wants to return the ...
|