| Thread | Last Post | Replies |
|
| Multiple worksheets within a workbook | 20 Apr 2006 22:59 GMT | 2 |
I want to set up a workbook with multiple sheets. I would like the document to open on an index page listing the worksheets the workbook contains. I also would like to name the worksheets something besides sheet one, sheet two, etc. I am a new user and am not very experienced ...
|
| Msgbox experts please reply.. | 20 Apr 2006 22:26 GMT | 8 |
hi.. Is it possible to have A msgbox that referes to all blank cells in a sellected range ? something like : "the cell(s) A1,B9,F12,... are blank."
|
| how do I use the solver to solve polynomial equations? | 20 Apr 2006 22:20 GMT | 2 |
|
| linking data to a form | 20 Apr 2006 22:16 GMT | 3 |
I would like to be able to have a link that pulls certain data from each row into an excel form. Each of our orders are entered into Excel on seperate rows. Is it possible to have a link "button" that opens an Excel form with data from a few of the
|
| Copy cells, preserve cell size | 20 Apr 2006 21:47 GMT | 2 |
Trying to copy cells from one worksheet to another but it doesn't preserve the cell sizes from the original. I tried paste special but it doesn't do it. Thank you,
|
| AutoFilter list problem | 20 Apr 2006 21:28 GMT | 3 |
I am using Excel 97. I have set the autofilter feature in Excel to the column labels. When I select the drop down arrow on column B, it does not show me all the unique data that could be selected in the list. I only see a portion of
|
| vlookup is returning a value one cell above the correct cell. | 20 Apr 2006 20:21 GMT | 4 |
i have a simple vlookup formula in one worksheet referenceing values in another worksheet, ie ' =vlookup(B2,otherworksheet!A2:D37,3) ' the data has been sorted, but the vlookup function continues to return a value from 'otherworksheet' that is physically one cell above the corect
|
| workbook code | 20 Apr 2006 20:15 GMT | 2 |
I am confused as to how to call functions from a procedure. My "ThisWorkbook" code creates new sheets and names them according to cells in a list on "Original Data" sheet and ten applies a function that shows or hides pictures depending on cell values. The problem is that the ...
|
| If function | 20 Apr 2006 19:54 GMT | 10 |
I have the following text string: Rcpt Revsed as Remit Faild on 02/15/06. Orig Paym Detl - PSON:BOB_23200937334 Orig Paymethd:DIR American Express C.Bnk:Credit Card Bank Rtng#: Acct#:3732-xxxx-xxxx-xx5 Exp Date:09/30/06 Ptech mesg:Call Voice
|
| automatic calculations | 20 Apr 2006 19:54 GMT | 3 |
I have tried to change the calculations in my spreadsheets to automatic from manual and then saving it into the xlstart folder, BUT this is not working. Other users use these spreadsheets and are not familiar with the F9 to recalculate.
|
| Circular:G4? | 20 Apr 2006 19:49 GMT | 4 |
My spread sheet has slowed down considerably, and I've notice on the very bottom bar of my excel sheet it now shows Circular:G4 What does this mean?
|
| Function - counting based on criteria | 20 Apr 2006 19:41 GMT | 2 |
I have a column of numbers. I need 3 formulas: (1) to count the numbers that are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the rows in the column that are blank. Any assistance would be greatly appreciated. Thanks.
|
| What | 20 Apr 2006 19:03 GMT | 2 |
|
| Gauss elimination / linear algebra. Please help. | 20 Apr 2006 18:39 GMT | 4 |
Hey guys and girls, I'm new to the forum and hoping you can help. I have a set of 6x6 "matrices" in excel that expand out to give 6 equations each with six unknowns (it is a formula for a composite lamina that has the 6 known moments and forces in a column on the left
|
| how do I display number in thousands; i.e diplay 123,500 as 124? | 20 Apr 2006 18:31 GMT | 1 |
how do I display a list of numbers in thousands? For instance, how to diplay 123,500 as 124 in a quick way, instead of putting formular of 123,500/1000? Thanks!
|