| Thread | Last Post | Replies |
|
| finding end of document | 17 Aug 2005 03:58 GMT | 1 |
Control end takes you to the end of the spreadsheet. My problem is if I have eliminated rows in the spreadsheet and then do control end it takes you to the end of the document that was originally there. I only want it to go to the new end of document. I work with large files ...
|
| colors | 17 Aug 2005 03:41 GMT | 3 |
Can anyone help me with colors using IF statement. Column A and Column B has numbers and Column C is a logical field to display thumps up or thumps down with colr green or red. I have Thumps Up symbol and Thumps Down Symbol from wingdings font. If
|
| when editing a comment box | 17 Aug 2005 01:08 GMT | 1 |
in excel row the box jumps over 1000 cells up or down. why is it doing this? this worksheet is autofiltered. does that have anything to do with it?
|
| Adding Column in an Excel Sheet by Command | 17 Aug 2005 01:08 GMT | 1 |
I need to add Column in an already existing sheet automatically i.e either programatically or with the help of a Macro
|
| count and limit radio button selections | 17 Aug 2005 01:06 GMT | 1 |
I want to take a poll with 4 answer options displayed as radio buttons. I want to tally the number of each option chosen for a specific question and I also want one of the options to be limited to the number of times it can be chosen . i.e. Options are Definately, Sounds Good, ...
|
| watermark | 17 Aug 2005 00:09 GMT | 2 |
how do i put a watermark such as draft and bkgrnd color on wksht
|
| text has numerical values | 16 Aug 2005 23:34 GMT | 5 |
I have a row of 15 cells. In some of these cells there is text. The text has numerical values such as V=1, M=0.5, and H=0.25. There are usually multiple combination of these text values and I would like to have a seperate cell show the SUM total within a range. I tried ...
|
| How do I calculate total hours by rate of pay? | 16 Aug 2005 23:18 GMT | 1 |
I am using a "start" time and "End" time field then calculating total hours by using the following formula =C2-B2+(C2<B2) which brings me the result for total hours spent on any given project. How can I apply these result to a rate of pay per hour to receive a total amount due ...
|
| Running filters using a macro | 16 Aug 2005 23:09 GMT | 1 |
I have 50 worksheets in a single workbook which all pull data from the same source document. Being that I need to perform this function monthly, is there any way to automate the filtering process using a macro?
|
| Sumif with a twist? | 16 Aug 2005 22:58 GMT | 1 |
43975000 50 43865000 100 43828000 5 43828001 21
|
| lookup and sum | 16 Aug 2005 22:48 GMT | 3 |
I have a worksheet on which I need a sum of data for accounts using info from another worksheet if the data on the second worksheet is associated with a given account on the first worksheet. Example:
|
| filter 15 worksheets so i can print all on one page | 16 Aug 2005 22:23 GMT | 1 |
i have about 15 worksheets that are pretty much set up with the same columns, I need to be able to print a worksheet with just the info I need. Like Filter it by number and then print. I am not worried about the headings. Can you please let me know if this is possible. Thanks.
|
| IF on the cell that contains it ? | 16 Aug 2005 21:35 GMT | 3 |
I actually don't know a lot about excel possibilities I'm trying to make a "x" go through a line something like for A10 : =IF(A1=0,"x","")&IF(A10="x","","")
|
| all worksheets have 2 descimals | 16 Aug 2005 21:14 GMT | 1 |
I can't clear my cells to general
|
| Grouping | 16 Aug 2005 21:07 GMT | 1 |
I need a spreadsheet "grouping" command to expand and collapse differently than the normal process seems to allow. For example: A list of: Year, Quarter, Month, Day (for multiple years). How can I group this data to collapse to Years only, Year/Quarter only,
|