| Thread | Last Post | Replies |
|
| How to add an arrow | 08 Mar 2007 23:41 GMT | 1 |
I have a front wooksheet which summaries the 4 other worksheets. I want a quick way to show if the volumes are improving or getting worse. So I wanted to put a bold green "up arrow" or red "down arrow" in the relative cells, but I do not know how to achieve this. At the
|
| Cannot COPY & PASTE | 08 Mar 2007 23:03 GMT | 1 |
I am probably doing something very stupid. I have been using EXCEL since it's inception, and have developed many worksheets and VBA code. I am not a newbie. My problem exists with one worksheet, no others. In fact, the problem does
|
| * Need serious help with formula/function * | 08 Mar 2007 22:59 GMT | 4 |
Here's an example of what I need... Cell Value _________________ D3 100.0000 <---------------- Random number entered
|
| dates | 08 Mar 2007 22:54 GMT | 1 |
how to change text dates (03082007) to mm/dd/yyyy (03/08/2007
|
| how do i save worksheet as a jpeg file | 08 Mar 2007 22:51 GMT | 3 |
i need to save excel worksheet as a jpeg file
|
| Format cells for special characters | 08 Mar 2007 21:51 GMT | 1 |
I downloaded a "to do List" that has a function whereby entering "a" into the cell, brings back the checkmark unicode character. How is this set up?
|
| Data Entry - Avoid Duplicates | 08 Mar 2007 21:45 GMT | 2 |
Is there anyway to set an alert or validation.. to avoid duplicates? For example: columnA abc123
|
| Macro Programing | 08 Mar 2007 19:23 GMT | 13 |
I do a payroll for my company on excel, and everyone but me is living in the stone age. They still haven't figured out =Sum(A1,A2). Anyways, I'm trying to write a macro to help me make less mistakes. If it was just straight equations, it would look sort of like this: ...
|
| Pivot, MSQuery or crafty use of MATCH and OFFSET? | 08 Mar 2007 18:15 GMT | 2 |
Please can someone give me a leg-up for the following: Prob1 - Easy (on same sheet) Rows are names (eg Brown, Smith, Jones...) Cols are Criteria (A, B, C, D...)
|
| Admin password to Individual protected worksheets by users | 08 Mar 2007 17:53 GMT | 4 |
I have an excel workbook where each individual sheet is protected by unique user. I want to add a admin id & password to this workbook so that the admin can access all sheets at the same time. (unprotect, unhide all
|
| Calculating Time | 08 Mar 2007 17:15 GMT | 2 |
I need to calculate hours to be worked in one cell. This spreadsheet will caluclate the hours scheduled for the week, then add them up and mulitply by payrate: 1 Mon(2) tue(3) wed(4)
|
| Specify BOLD within a formula? | 08 Mar 2007 16:41 GMT | 6 |
I have a formula which looks up 2 text strings (at least part of them) and concatenates them. Is there any way to have the second text string display in BOLD by somehow specifying this within the formula? =LEFT(VLOOKUP(B12,Derivative,4,FALSE),FIND("(",VLOOKUP(B12,Derivative,4 ...
|
| Increment Formula | 08 Mar 2007 15:45 GMT | 5 |
I use the following formula to pull values from an external spreadsheet. If I use the Auto-fill option to populate cells in the destination file it copies the formula exactly. How can I get it to increment the last digit when copying down a column
|
| Excel Merge | 08 Mar 2007 15:32 GMT | 1 |
I have been given an assignment to do a "mail merge" in Excel. The names and addresses are in a document in Excel and the person does not want to have to have the information typed again. Is this possible? I believe a mail merge would have to be done in Word or Access. By
|
| Time Save msg box | 08 Mar 2007 15:31 GMT | 5 |
Is it possible to have a message box pop up every hour to remind people to save the workbook, as we use a sheet for a period of 24 hrs and often it is closed without saving, i did use the auto save on workbook close event, but this is still not
|