| Thread | Last Post | Replies |
|
| #VALUE! When Attempting To SUM A Funtion that Does Not Print "FALSE" | 28 Feb 2007 23:24 GMT | 1 |
Here's what I'm trying to do. I have a few rows of cells executing a function that inserts a dollar amount when "Yes" is entered in the adjacent cell. Here's what the cell looks like
|
| Calculate single sheet only? | 28 Feb 2007 22:41 GMT | 2 |
I am using excel 2002 and have a large workbook litteredwith complicated formulas. As I input large amounts of data, the calculation ( I have it set to calculate on close of F9 only) time takes 3-4 minutes, as it is calucating every formula in every sheet.
|
| Delete Columns | 28 Feb 2007 22:15 GMT | 1 |
In Excel, I need a macro that will delete a column based on a cell that will contain a name based on an input box. Thanks, Bernie
|
| very slow first time i make a cell bold | 28 Feb 2007 21:29 GMT | 5 |
I have noticed an odd behaviour with Excel 2003. After opening the application, the first time I make a single cell or a range of cells bold (or italic or underlined or "un-bold", etc), the operation takes an unduly long time--10-15 seconds, during which Excel is unresponsive.
|
| Copy chart into Word exactly! | 28 Feb 2007 21:25 GMT | 1 |
I have a full page landscape chart in excel, I want to be able to copy this page into word, but whenever I try and copy and paste it, the whole thing reformats and half the axes text has disappeared etc. Surely there must be a way around this?
|
| populating mulitple worksheets | 28 Feb 2007 21:08 GMT | 3 |
I have a book that has 4 sheets in it. Master, DEAD, WON, PENDING. In the master sheet there is a list of sales opportunites, and as the name sugests its a master list regardless of status. There is one column named status that would be DEAD WON, or PENDING. (you might
|
| Excell | 28 Feb 2007 20:01 GMT | 1 |
Does anyone no how to set a formula to do this, there is different ranges like 0-499,500-799,800-999 and with each range there is a perentage attached like 0-499=1%,500-799=2%,800-999=3%. If a price falls into the range need the percentage like 303=3.03 or 805=24.15. thanks
|
| Formula to calculate text or letter in cell | 28 Feb 2007 19:37 GMT | 3 |
I've done this before, but cant remember how and I cant find anything in help or on the internet. I need a formula to calculate whether a specified cell has text letters in it or numbers in it.
|
| Cannot insert new rows | 28 Feb 2007 19:31 GMT | 2 |
I am running excel 2007 and I have 23 worksheets in a workbook. I have no links or hidden rows or colums. My biggest sheet is A1: AW8096. I use VB macros to add lines and move data from one set of workbooks to this one. I have built several sheets using this proceedure.
|
| Slanting headers | 28 Feb 2007 19:30 GMT | 4 |
I saw a spreadsheet where the column headers slanted up at a 45 degree angle from the rest of the column. This made it much easier to have long, descriptive headers without having to word-wrap or widen the column (the column contents were mostly markers, like x's, so the
|
| Call Macro if no Dependents | 28 Feb 2007 19:23 GMT | 1 |
First of all any help would be great. I have a macro which shows the Trace Dependents Audit Arrows. I would like to add to it to check for any cell that contains data call a particular macro. This other macro interacts with another application as well as excel
|
| Counting contents for Saturday dates within a range | 28 Feb 2007 18:50 GMT | 3 |
I am trying to find all Saturdays within a range(on row 14), and if a Saturday is detected, then I would like to add the values in the corresponding row for the Saturday only dates(available in row 16). After going through the date range, and the total sum is zero, then I
|
| more in Max min relatives | 28 Feb 2007 18:33 GMT | 6 |
Say I have n points(values): P1,P2,.... Pn I want to define a minimum relative if, for example a point (P3) has a value lower than X points after and X points before. If X=2 then: P1>P2>P3 and P3<P4<P5 then P3 is a minimum. or
|
| export to email | 28 Feb 2007 18:26 GMT | 2 |
is there a way to code a macro or vba to export a range of cells into an outlook email either as an attachment or as the body of the email? Brian
|
| Sum corresponding row values for Saturday only dates within a date range | 28 Feb 2007 17:16 GMT | 3 |
I am trying to find all Saturdays within a range(on row 14), and if a Saturday is detected, then I would like to add the values in the corresponding row for the Saturday only dates(available in row 16). After going through the date range, if the total sum is zero, then I
|