| Thread | Last Post | Replies |
|
| copying and pasting | 01 May 2006 21:25 GMT | 2 |
Hi I have 2 questions 1) I am making up a rota of shift people are working etc and opened up a new excel which has 3 pages to it. I made up a page with names etc down the left colum and their duties etc will be inserted along the rows. I arranged all
|
| Can a Works spreadsheet be password protected? | 01 May 2006 18:58 GMT | 1 |
I've looked in every menu and tried the help function in MS Works and cannot find a way to password protect a spreadsheet. It is possible to password protect an MS Works spreadsheet?
|
| How to get a bulletpoint in Excel? | 01 May 2006 18:53 GMT | 2 |
What's the easies way of getting a bulletpoint. I'm wanting to avoiding using Wingdings (as you can only have one font per cell from what I can see). And I'm wanting a bulletpoint & text in the same cell (without complex VB). Are ther any simple key combinations? I know the mac one ...
|
| Multiple Local Statements | 01 May 2006 18:40 GMT | 5 |
I am trying to get a value of XX in 1 box only for many situations.. Such as If A1 is less than 1.4 then cell is to read "90% if A1 is > or = to 1.4 BUT less than 2.1 then read 77% If A1 is > or = to 2.1 BUT less than 3.25 then read 70%
|
| Anyone know of a forum like this one that deals with MS Word? | 01 May 2006 18:36 GMT | 2 |
I know this is a forum for Excel, but I'm wondering if anyone here knows of similar forum that deals with MS Word? I need to write a small marco that will enable me to automatically insert a table and picture based on input elsewhere in the document.
|
| greater to or less than formula | 01 May 2006 18:32 GMT | 4 |
I'd like to try two formulas, they read as follows: IF F23 IS LESS THAN OR EQUAL TO 30 THEN ((F23*F23)*0.785), IF F23 I MORE THAN 30 THEN ((F23*F23)*-0.335)+(F23*69.3)-1087) the second is:
|
| Problem with my formulas | 01 May 2006 18:13 GMT | 1 |
I simply placed an equal sign in a cell and clicked the worksheet i wanted to reference. When i first created this worksheet everything worked fine. But now, over time, it has generated this: ='C:\Documents and Settings\FPHC\Desktop\Open Projects\Electronic Daily
|
| Excel Macro VBA Help Needed | 01 May 2006 17:12 GMT | 1 |
I have a sheet which has been copied from a pivot table. I need it to perform the following: Find a cell with specific text (Yes) Move over three columns (I have been using an offset)
|
| Forcasting | 01 May 2006 16:07 GMT | 2 |
I have some call volume data and I would like to forcast the next pay periods volume. My table looks like this. PP AHT Volume ServieL FTE Cost
|
| Autoinsert new rows in Excel | 01 May 2006 16:00 GMT | 1 |
How can I make Excel autoinsert a new row BEFORE the summary row, row that would copy all formulas from the previous row? This event should ONLY occur when required cells are filled. Thanks a lot!
|
| Help please | 01 May 2006 15:13 GMT | 1 |
I want to write a formula that would link text into another worksheet i there was text on a certain cell, if blank it would not link to th other worksheet. Example: if column A contains a number and Column contains a description, the number and decription would print on th
|
| Please Help!!!! | 01 May 2006 14:52 GMT | 4 |
i KNOW NOTHING ABOUT EXCEL, AND I AVE BEEN TRYING TO FIGURE IT OUT FOR TO LONG HOW IT WORKS, I JUST WANNA DO A SIMPLE TASK, I WANNA KNOW IF ITS POSSIBLE: I HAVE A BUNCH OF NUMBER FROM 0000 TO 9999 AND I WANT TO KNOW WHICH NUMBERS ARE NOT IN MY LIST.
|
| Deleting a space between a group of Numbers & Letters in a cell | 01 May 2006 13:35 GMT | 6 |
I'm trying to delete a single space between a group od items: ACE 12408 ------------I'm looking for ACE12408 I have over 10,000 lines so I'm looking for a shortcut.....Help ME please!!! Thanks
|
| Changing line colour by action | 01 May 2006 11:13 GMT | 2 |
Is it possible to change the colour of a colour by formula? Say that if box A4 has the word ok in it to change the colour of the line it’s on to red? I haven’t used an IF command to do this before and am not even sure if it’s possible.
|
| Subtotal | 01 May 2006 09:53 GMT | 1 |
I have a sheet containing Customer, State, Sales, Outstanding. - I would like to find the contribution of each Customer against the total sales for the state in which he/she is located. - I would like to sub-total for each state only customers who have
|