| Thread | Last Post | Replies |
|
| out of range error | 18 Sep 2005 00:12 GMT | 9 |
Help please! Why am I getting a Runtime error 9 subscript out of range error on this statement? Workbooks("filename.xls").Worksheets("Sheet1").Select Many TIAs
|
| Entering Numbers with 2 Decimal Places - Automatically | 17 Sep 2005 21:48 GMT | 2 |
I've been using Excel for years, yet this is my first time on this newsgroup. When reconciling my checkbook, I can set my 10-key calculator to 2 decimal places, so that whenever I enter a number, it automatically converts it to
|
| Principle reduction question | 17 Sep 2005 19:30 GMT | 7 |
I know how do use the pmt() function to calculate mortgage payments but I need to know the easiest way to calculate the total principle reduction/remaining balance after a set number of payments without doing an amortization table.
|
| Extracting images | 17 Sep 2005 12:22 GMT | 2 |
I use Microsoft Office Excel 2003 SP1 I've been sent a spreadsheet that has some cells containing images. How do I extract the images to save them separately?
|
| tabs | 17 Sep 2005 09:18 GMT | 1 |
I want to add pulldown menus on some of my fields. Can someone lead me in the right direction on how to do this? You know...I need to have choices so I do have to type the thing in all the time. I just click on the arrow and bring the pulldown down and choose the correct text.
|
| Macro wont run | 17 Sep 2005 01:05 GMT | 1 |
The macro below wont run. When I select a column of data ie: A2:A58 it is suppose to delete the entire row if a cell in my selection is blank. All my other macros run OK. I'm running Excel 2003.
|
| If "text" exist within "cell" then TRUE | 17 Sep 2005 00:41 GMT | 7 |
I cant find a way to look up if a string of text exist within a cell and reply with TRUE or FALSE, such as "if "text" exist somewhere within "cell" then TRUE". I have a list that looks something like:
|
| How do I set up a Doubles Tennis roster for 12 players? | 17 Sep 2005 00:31 GMT | 3 |
The Idea is that all players play once with each other & the scores are tabled showing which the best partnership/ players are - I'm stuffed !
|
| Edit-Find doesn' work, don't know the problem. | 17 Sep 2005 00:27 GMT | 1 |
I'm using an excel document and I want to use the Edit-Find feature to locate names within the document. I know the names are there because I've put them in and when I use the Edit-Find it doesn't work. I don't the problem and would really appreciate some help.
|
| testtest | 17 Sep 2005 00:07 GMT | 1 |
|
| Pivot table discarded to due to integrity problems | 16 Sep 2005 23:41 GMT | 3 |
I have a client with a mid-sized workbook. On one page is a pivot table. Occasionally, upon opening the workbook an message appears about errors being detected in the pivot table. The result is that the workbook opens, but the worksheet with the pivot has now become "flat data". The ...
|
| Calculate total of only visible data. | 16 Sep 2005 22:13 GMT | 2 |
I have attached a zip file of my actual data sample. First run the macr (a) macCreateDetailRpt and then (b) macFormatDetailRpt The data is about the training given to employees of different compan either web-based or via Instructor. The total field for each mont
|
| Offset Problem | 16 Sep 2005 20:03 GMT | 1 |
=OFFSET(`[worksheet05.xls]PROCESS LOG`!$K$9,B9-4,0,1,1) This formula linked to another spreadsheet previously worked, but a ne workbook has been created and the formula now returns a "0" value to th cells?
|
| take sum of 6 different values and then * that answer by a % | 16 Sep 2005 19:48 GMT | 1 |
I am trying to numbers from different cells and add them for a total and then multiply that number by a percent to get my answer. I can't figure out how to make this formula. Example c10+d10+e10+f10 +j10+m10 and then that total *by a percent.
|
| Permutation in excel | 16 Sep 2005 19:14 GMT | 8 |
I´me a new member in your forum, can somebody help me to solve this problem in excel please: I need to make combinations with a makro or a funktion in excel as followed:
|