| Thread | Last Post | Replies |
|
| worksheet names | 06 Oct 2004 13:59 GMT | 2 |
Is it possible to create a list of the worksheet names within the same file? I received a file that has 40 worksheets. I need those 40 names in a text list. Is there a better way than cut-n-pasting?
|
| How can I create an invoicing database in Excel? | 06 Oct 2004 12:54 GMT | 2 |
I would like to know how to create an invoicing database, or register in Excel. (Invoice + tax = total) Are there any templates free online? thanks
|
| dynamic named range | 06 Oct 2004 12:33 GMT | 2 |
I have a dyanimce names range that starts in Cell A1. The formul behined the dyanimc range is: =Offset(A1,0,0,Counta(A1;A65000),1) This works fine if I have blank values. But what if the blank value
|
| Copy-Paste Subtotals in Filtered Lists | 06 Oct 2004 12:09 GMT | 2 |
Is it possible to paste just the subtotals from a filtered list. I hav tried to copy and paste the second level in outline view but when paste I get the whole list rather than just the subtotals --
|
| Huge spreadsheet spanning 600 rows... | 06 Oct 2004 12:05 GMT | 4 |
User wanted this to print on 11x14..it spanned the entire page and then some..where would I first look to edit to make this easy to read.
|
| Handle on cell selector disappeared.. | 06 Oct 2004 11:29 GMT | 2 |
Fired up excel today just to see a very strange problem.. no handles on selections at all. When I select the cells, its just a simple selection.. no little cross at the bottom right. Can't drag, copy .. do anything. Any suggestions on how to bring the handles back on?
|
| a simple question | 06 Oct 2004 08:18 GMT | 1 |
I am using the Ctrl key to select a number of cells at one time. if make a mistake how do i de-select a cell but still retain the selectio of the others? eg. I want to select the cells A1, A2, A4, A5. I hold Ctrl and click a
|
| 2 step LOOKUP? Vector, array? Help. | 06 Oct 2004 06:54 GMT | 1 |
Need Help! I've got a Data spreadsheet looking like the following: Start | End | Class | 1 | 2 | 3 | ... thru to | 150 | 1 | 5 | 1 | 12.25 | 13.50 | 10.00 | ... assorted #s unde
|
| can it be done without notice | 06 Oct 2004 06:51 GMT | 10 |
The below code (which was given in this NG + With some minor alterations by me) intends to check if anything is changed on column J then email that changed info to a spesific email address without the notice of the workbook user...
|
| forecast function help | 06 Oct 2004 06:12 GMT | 1 |
Just to clarify that formula, am i right to say this? =ROUND(FORECAST($E$1,B2:D2,$B$1:$D$1),0) $E$1 - is selecting the forcast for year 2004 B2:D2 - is selecting all the data bar the years in the top row
|
| forget VBA password | 06 Oct 2004 06:10 GMT | 1 |
I have forgot the password of VBA editor..how to hack it??
|
| SumProduct/SUMIF? | 06 Oct 2004 03:13 GMT | 3 |
ok here is my data: columnA ACCOUNT EXE Jason
|
| Help killing Excel | 06 Oct 2004 02:17 GMT | 2 |
This code works for ~20 sets of excel workbooks. ONE of the sets (a single workbook) always crashes the workbook, with a request to contact MS with the error report. The last crash gave me a DDE server crash error. Is there any thing in the sheet that would cause this?
|
| How do I get XL2003 to default save overwriting the original? | 06 Oct 2004 02:06 GMT | 4 |
|
| what program would be best for listing movie in alphabetical orde. | 06 Oct 2004 01:34 GMT | 2 |
|