| Thread | Last Post | Replies |
|
| total Hours Worked for week PS thx for the formulars everyone! | 09 Sep 2007 06:36 GMT | 1 |
Mon Tue A1 B1 7:00 7:00 Start Time A2 B2
|
| Copy & Pasting Excel Spreadsheet to CorelDraw | 09 Sep 2007 02:58 GMT | 1 |
I have just upgraded to Office 2007 on my Dell Laptop from Office 2000. I have created invoices in CorelDraw 9 but have copy/pasted Excel spreadsheets for numerical data on the CorelDraw pages for years with no problem. Since the Office upgrade, the Excel 2007 spreadsheet data ...
|
| change parameters of a range to be summed | 09 Sep 2007 02:34 GMT | 2 |
hi, I have a macro in a worksheet that selects the last populated cell in a range (D18:V18), copies the formula from this cell and pastes it into the next empty cell to the right. I wish to then create a formula in cell Y18 that will sum only the range from the newly populated ...
|
| charting question | 08 Sep 2007 23:55 GMT | 3 |
I am charting cells formated as percentages in a pie graph using Excel 2003. Is there a way to not show the 0% values in the pie chart? Thank you David
|
| Sliding scale commission percentages formulas | 08 Sep 2007 23:33 GMT | 7 |
How would I make this table apply to each cell that contains my different sales % figures in order to see what my Rate Earned would be? I am a total novice. Thank you in advance. Sales % Achieved Rate Earned
|
| IF statement pulling from Product List | 08 Sep 2007 22:09 GMT | 5 |
I'm trying to setup a simple tracking system with a product list. What I want to do is have one sheet list all the product information (item name, number, cost, etc), and have another that tracks each customer's order. I want to input the product number on the customers order, ...
|
| Excel applications for a Barcode scanner | 08 Sep 2007 19:34 GMT | 3 |
Currently, I am able to scan barcodes from a scanner which opens up an Excel file and verifies the UPC code on the product. What I need to do is set up a table that will then show the price equated with the UPC. I'm thinking a VLookup would work since I have about 20 UPC I must ...
|
| Excel 2003 Identify a single character in column | 08 Sep 2007 19:16 GMT | 2 |
I have a list of student usernames for our website. Generally the default is firstname.lastname but some students have firstname1.lastname. I am trying to identify all the students with firstname1.lastname and I would like to run a conditional format that identifies all cells ...
|
| Shared workbook | 08 Sep 2007 17:11 GMT | 1 |
I have a spreadsheet that is shared between 8 people on a network. Is it possible to protect this so that each person only sees the parts of the worksheet that is relevant to them, but have the whole thing available to the administrator?
|
| Designating color in one cell based on data entered in another cel | 08 Sep 2007 16:55 GMT | 3 |
I need a way (formula, format, etc) for the background color in one cell to be determined by the data entered in another cell. For example: Cell C6 will have a number manually entered. Cell D6 will have a single letter manually entered into it. Based on the letter entered in ...
|
| IF function | 08 Sep 2007 14:48 GMT | 3 |
Hi - I have a spreadsheet which I record all my monthly outgoings in. I put a tick in column E against each amount when it's come out of my account. Can anyone tell me if there is a way of getting column F to read £0 when I've put the tick in column E?
|
| SUMPRODUCT to count items with duplicates where another column contains two defined items | 08 Sep 2007 10:33 GMT | 4 |
Ok, I think this is a SUMPRODUCT delima. A B C D z 1 q 1
|
| How to create link b/n Excel worksheet (cell) and Word document? | 08 Sep 2007 07:22 GMT | 3 |
I need to insert a link into specific cell of an Excel worksheet to a specific part of a word document. I have tried using Hypserlink - doesn't work. I have tried using Copy, Paster Special as a link - doesn't work either.
|
| Deduct Months from a Date | 08 Sep 2007 04:22 GMT | 6 |
In Column 'D' I have a list of dates in the form MMMM/YYY Column 'E' contains whole numbers which represent a no. of months In column 'F' I wish to deduct the number of months in 'E' from 'D' Can anyone help?
|
| cell with static current time | 08 Sep 2007 02:42 GMT | 8 |
i would like a cells in a column to display the curent static time the cell in the previous column is a certain value ex: if cell value is "out" or not "in" then next cell to display when value
|