| Thread | Last Post | Replies |
|
| Remove last letter from column | 06 Sep 2007 19:55 GMT | 6 |
Hi, I have a list of titles and some titles have a letter A or B at the end.. is there a function/formula I can use to remove them if it ends in A or B? For example (my list):
|
| Page numbers when printing multiple sheets | 06 Sep 2007 19:39 GMT | 2 |
I am trying to get my whole workbook to print out as a single document. I select all 30 of the worksheets, and print. It works fantastically, except the page numbering. It usually prints on about 125 pages, Sheet1 prints on two pages, so the page numbering in the footer goes: ...
|
| Copy a formula formatted as Text In Excel | 06 Sep 2007 19:35 GMT | 2 |
I have a UDF that returns the formula of a given cell in a text format. Is there anyway to have excel recognize that the result of the function is a formula and not text. Once I click on the cell, hit F2 to edit it and then enter, Excel
|
| exit excel step by step | 06 Sep 2007 17:44 GMT | 5 |
When I double-click an excel file the following happens: - excel opens - a blank workbook opens (like a new workbook) - the file which I selected opens in Excel
|
| Formatting Cells using an If Statement | 06 Sep 2007 16:39 GMT | 4 |
Hi, I am wondering if anyone knows, is there a way to format a cell based on it's value using an IF statement? For example I want to enter a worksheet function that would change a cells font color to red if it exceeds a certain value.
|
| Excel 2003: Cannot access directory | 06 Sep 2007 15:00 GMT | 3 |
I have a second hard drive where I store my files. The windows mapping originally mapped it as drive "F". I have added a 2nd DVD burner recently and now my second hard drive is mapped to "G". In my Excel 2003, under Tools:Options, when I click the Save tab, it gives me an ...
|
| Error when hyperlinking to PDF | 06 Sep 2007 14:50 GMT | 2 |
I receive this: "No program is registered to oen this file." I have checked the PDF's permissions, paths, etc and all that side is fine. The PDF's open FINE when going to the directory. Only errors when linking from Excel (2003).
|
| Metric conversion formula / function | 06 Sep 2007 14:48 GMT | 8 |
I'm modifying a worksheet for our Quality Control dept. where I have to take metric dimensions (millimeters) off a print and convert them into English / Imperial (inches) for the guys to check parts from. Anybody know if there is a way to enter a metric dimension and have
|
| checkbox | 06 Sep 2007 14:31 GMT | 1 |
I want to add a checkbox in a column so the user can check it for yes or no. Is there a way to do this?
|
| character count | 06 Sep 2007 14:18 GMT | 3 |
How to count the character count in a particular cell. Ex: A1="Welcome to Excel" count e in A1
|
| Table of contents with hyperlinks to worksheets, plus "home" hyperlink | 06 Sep 2007 13:43 GMT | 2 |
I would like to find a way to insert a "Home" hyperlink on all worksheets in a workbook. The hyperlink should link to Sheet1!A1 (my table of contents worksheet). Presently I have to enter the hyperlink one a time on each worksheet.
|
| Delete rows from one sheet containing deatils on the second sheet | 06 Sep 2007 11:10 GMT | 4 |
I need help - please: I have 2 Excel sheets: 1 – Contains all contact details (aaprx 900 rows) 2- Contains email addresses which have bounced back over the past 3 months
|
| share/ link info between sheets | 06 Sep 2007 08:28 GMT | 2 |
I have created formulas is sheet 1. I want to create a table in sheet 2 using totals from sheet 1. How do I work with formulas between sheets?
|
| deleting rows from one sheet based on 2nd sheet | 06 Sep 2007 07:38 GMT | 1 |
I need help - please: I have 2 Excel sheets: 1 – Contains all contact details (aaprx 900 rows) 2- Contains email addresses which have bounced back over the past 3 months
|
| Write Code that creates expiration date | 06 Sep 2007 07:31 GMT | 2 |
I want to write a routine that allows someone to use the template for a certain time period. After that time period, I want them to stop using the program without renewing so the information stays current. The following routine will work, except I want the value to be stored
|