| Thread | Last Post | Replies |
|
| Drop down box | 22 Sep 2006 19:07 GMT | 1 |
If I choose a word/command/field from the drop down box, how can I format the next cell over recognize this selection and display a number? Basically I created a drop down box, Van, Bus, etc...
|
| What does the symbol <> mean in an Excel formula? | 22 Sep 2006 19:05 GMT | 1 |
|
| How do I view the header/footer when working on a worksheet | 22 Sep 2006 18:48 GMT | 2 |
I have created a Header or footer on a worksheet in Excel. How do I view that header or footer when I am working in that worksheet?
|
| Code Woes | 22 Sep 2006 18:30 GMT | 10 |
After protecting my worksheet, this code only works sometime - that is the conditional statements. Also, Cancel=True does not seem to be working as the cursor remains in the field after double clicking the selection. Here's the code in its entirety: (It works fine when I ...
|
| Add number into one cell to remove from another cell. | 22 Sep 2006 18:24 GMT | 2 |
Does anyone know how to add a number into one cell and have that same number removed from another cell? (Even by changing font to match the background) I want to list consecutive numbers in one cell (eg. 1,2,3,4,5,6) and have each of these numbers removed one by one as I add each ...
|
| Creating a chart using selected cells from worksheet | 22 Sep 2006 17:55 GMT | 2 |
I would like to create a pie chart using selected amounts on a worksheet. The work sheet is set up with columns for each month. In each colum there are 8 totals with blank cells between each total. When I do the pie chart it includeds the blanks therefore making a pie chart
|
| How can I find the 10 lowest numbers in a list? | 22 Sep 2006 17:48 GMT | 5 |
Is there a way to find the 10 lowest numbers in a list? No problem finding one minimum, but need 10 lowest. Thanks in advance.
|
| VLookup | 22 Sep 2006 17:09 GMT | 1 |
I need to find a specific P/N on several spreadsheets and add up the sum of the parts which is entered in column 7. The P/N's are not necessarily on all sheets.
|
| Refresh Data in Excel Spreadsheet | 22 Sep 2006 16:53 GMT | 2 |
How do I refresh data in MS-Excel 2003 w/o manually pressing F2 and enter? The issue is I have a coulnmn that was brought in from an external data source as text format, when the column should have been accounting format or currency format. When I re-format the column to ...
|
| Automatic Filtering | 22 Sep 2006 16:47 GMT | 4 |
Is there a way to create a filter that accomplishes the following: Example Speradsheet A B 1
|
| Conditionally consolidating lines within a spreadsheet | 22 Sep 2006 16:45 GMT | 1 |
I have a payments file (BACS file) that is a CSV file. The file contains payments to payees containing name, account details and values. Most of the time each line is unique but occasionally there may be two or more payments to the same payee on consequtive lines (they are always ...
|
| Importing | 22 Sep 2006 16:30 GMT | 1 |
Import from Excel to Word without losing column formatting.
|
| Shared Workbook Ability For Users To Enter New Records. | 22 Sep 2006 16:28 GMT | 1 |
Hello! I have been given the task of creating a shared workbook to be used at 30 locations around the country. There will be one user at each location using the workbook. I have the workbook desigend, heavy with validation, tips to enter their data etc to make it as foolproof ...
|
| Percent of | 22 Sep 2006 16:22 GMT | 3 |
Good morning everyone, this is a simple formula that I can't put my finger on for some reason this morning, but I'd appreciate some help. I'm trying to track training completions in Cell A2 I have the total amount of employees.
|
| calculate percentage in pivot | 22 Sep 2006 16:16 GMT | 1 |
Please would someone let me know if it is possible to add a field into a pivot table which calculates each field's value as a percentage of the total? For example, I have a pivot table which shows the following SALES
|