| Thread | Last Post | Replies |
|
| Named somewhere - but not by me. | 06 Jun 2005 13:33 GMT | 2 |
I have a spreadsheet that I have created with a few sheets in it, I have been trying to copy a sheet from this excel document to a completely new excel document. When i try to drag the sheet over I get an error message telling me
|
| Clueless as to how to write VLOOKUP formula | 06 Jun 2005 13:26 GMT | 3 |
I have just started a summer class that is basically an Excel class. The teacher doesn't really show us how to do anything and I am a novice excel user at best. I have a lab that requires us to use VLOOKUP and I am totally lost. Anyone have any tips on a training website or where ...
|
| Formulas and background color used by a cell | 06 Jun 2005 13:22 GMT | 1 |
Is it possible to create a formula that outputs a different result depending on the background color used by a particular cell? Something along the lines of:- =IF(AND(A1="Test",COLOR=RED)=TRUE,"Test true","Test false")
|
| modified date | 06 Jun 2005 12:50 GMT | 1 |
Can i set up a sheet within a workbook that will give the date and the username of every person who modifies the spreadsheet. THANKS MONTY
|
| Combo box | 06 Jun 2005 12:26 GMT | 3 |
if i set up a combo box in worksheet 2 can i have the name a select in this combo box put into a cell in worksheet on. thanks for your help
|
| I was messing arround with the VBA and now I get the macro warning when I open the work book but when... | 06 Jun 2005 08:07 GMT | 2 |
I look in the macros none are listed to delete. What or where should I look? Marc
|
| Formula - Amortization | 06 Jun 2005 06:57 GMT | 3 |
Can anyone provide a formula to calculate loan payments within a worksheet to amortize a mortgage - i.e. term, rate, and amount given? I need to auto calculate a couple variables for 15, 20, 25, and 30 years. Thanks!
|
| how do i print a list of files in a folder in excel? | 06 Jun 2005 04:28 GMT | 4 |
I would like to print a list of my files that are in my folders
|
| Macro cannot be disabled nor signed. | 06 Jun 2005 03:02 GMT | 3 |
Following Error message. "This workbook contains a type of macro (Microsoft Excel version 4.0 macro) that cannot be disabled nor signed. Therefore, this workbook cannot be opened under High Security Level."
|
| how do i open e-mail attachment with spreadsheet | 05 Jun 2005 20:10 GMT | 1 |
i now have excel and microsoft office but i received an e-mail with an attachment (spreadsheet). the attachment is a GLGI 2005 calculator. i do not know how to open it so i can read it.
|
| How can I put a slash in a zero in Office 97 | 05 Jun 2005 19:32 GMT | 3 |
How can I put a slash in a zero in Office 97
|
| Maximum Worksheets | 05 Jun 2005 19:01 GMT | 2 |
What is the maximum number of worksheets in a workbook and does this vary per version?
|
| can u explain this line for me? | 05 Jun 2005 13:04 GMT | 4 |
i am unfamiliar with vbasic syntax..so what is Intersect( ) and Is Nothing?
|
| How to run a macro when user enters a value in a cell? | 05 Jun 2005 12:53 GMT | 5 |
See the question about vbasic functions below also.
|
| Converting Minutes:Seconds to Minutes | 05 Jun 2005 09:38 GMT | 9 |
I could download my telephone bill online. When I view the bill online The Duration of Call column which is listed in minutes appears as (for example) 5:00 ..............(for 5 minutes)
|