| Thread | Last Post | Replies |
|
| HOW DO I E-MAIL WORKSHEET AS IS WITH ALL FORMULAS, ETC? | 15 Aug 2008 22:44 GMT | 1 |
Trying to e-mail a financial worksheet and only print out sent, not the sheet in the workbook with formulas, etc. Is there a way to do that? When I click the Office Button and go down to send, only choice there is "Inernet Fax". Tried "e-mail" under commands and only print of ...
|
| Need to pick up data from left of a space starting from the right? | 15 Aug 2008 22:40 GMT | 3 |
1 4210210 134.40 2 30362920 395.40 3 820401-2 116.20 4 728435514 5152.06
|
| Next time sheet is touched, remove items from cells? | 15 Aug 2008 22:02 GMT | 3 |
I had this before and did not get any takers. I think the chalenge is more getting to do it once and not to check each time? ============= Not sure how to do this, but I have a sheet that I have a macro export data
|
| Select, find in another book, copy, return and paste | 15 Aug 2008 21:42 GMT | 3 |
Excel 2003 I have multiple catalogue workbooks, all use the same layout. I want to update the on hand stock in column H for the item numbers I select in column B. All on hands are in workbook peter1.xls in column G.
|
| Formula for formatting font/style | 15 Aug 2008 21:37 GMT | 2 |
I am creating a spreadsheet where, in a certian column, each entry starts with a bold capital letter that codes for something, followed by a text description. I am hoping a formula or setting exists so that I can type my information in and automatically capitalize and bold the ...
|
| X EQUALS A NUMBER | 15 Aug 2008 21:20 GMT | 3 |
I would like to place an x in a cell and it repesents a number: For example: Always Frequently Occationally Seldom Never =1 =2 =3 =4 =5
|
| Still trying to average 4 worksheets and having formula problems | 15 Aug 2008 21:01 GMT | 3 |
Basically I need the average of 4 cells on separate worksheets with 1 or more cells having a DIV/O message. A little background: these 4 worksheets are the quarterly results (averages from the monthly workbooks) then I need a formula that averages the quarters to make a ...
|
| PivotTable - Sum and Count | 15 Aug 2008 20:59 GMT | 1 |
As part of my PivotTable, in the Data field I have 2 columns, one for the Sum of a value and one is for the count of another value. The PivotTable displays what I want, each on a row, but I would like the currency sign to appear on sum values but not of course on the count ...
|
| creating a quote | 15 Aug 2008 20:42 GMT | 7 |
|
| Format row color based on individual cell | 15 Aug 2008 20:22 GMT | 5 |
I have a list of work orders. In column G, they are listed as being one of four types, A, b, c, or d. I would like row 1 to have a background color based on the type in column g. I would like to do this throughout the spreadsheet. I have tried conditional formating, but I ...
|
| Maximum Allowed Rows | 15 Aug 2008 20:08 GMT | 5 |
I need to exceed the 65536 rows allowed in Excel. My work needs to be saved in the csv format, and it must be a single column. Is there any way I can create a single column with several hundred thousand rows?
|
| Compati Checker - erroneous links warning | 15 Aug 2008 20:02 GMT | 3 |
I copied a sheet from one workbook to a new one where it is the only sheet. Every time I try to save the new workbook (in XL11 format) I get the Compati Checker warning me about links to unopened workbooks - even citing 6 occurences. Problem is that:
|
| Using index and match | 15 Aug 2008 19:48 GMT | 5 |
I’m, trying to use an index and match function to return text from cells on anther sheet. =INDEX(Formulas!$J$3:$K$6,MATCH(AM7,Formulas!$J$3:$K$6)) The formula looks for a value that matches AM7, it is suppose to return text from cells on another page shown below. I keep getting ...
|
| Select Wich Cells To Include In Print | 15 Aug 2008 19:44 GMT | 2 |
Good Evening All, Excel 2007. I have a ss (report), in which I have included notes for the user, eg 'click on button to refresh data'. These notes have been placed directly in
|
| Scheduling Functions | 15 Aug 2008 19:25 GMT | 5 |
I'm creating a spreadsheet to track approaching deadlines for tasks to be completed (on a construction project). I'm trying to figure out if there is a function/formula that I can use to highlight cells as the dates approach. For example, if today is 8/15/08, all cells that ...
|