| Thread | Last Post | Replies |
|
| Pivot table breakdown | 24 Feb 2006 19:41 GMT | 1 |
I have a pivot table showing a top 10 from a list of 400 and i want to be able to produce 10 seperate sheets 1 for each of the top 10, I know i can do it by clicking on the totals but is there a way i can do it so i can include it in a macro ?
|
| Landscape printing? | 24 Feb 2006 19:38 GMT | 2 |
I used to be able to print a roster created in Excel in landscape but now it will only print in portrait and 3 columns are deleted from the right side of the page. I can't figure out what I did to make this happen. Can you please help?
|
| need help with Outlook/Excel interface | 24 Feb 2006 19:36 GMT | 3 |
how can I copy multiple Excel files from Outlook (all at once) into Excel? Is there a way to do this? When I right click ONE file attached to the email, I can copy it, either using My Computer, or opening the directory within Excel. BUT, if I clik 2 or more, and try to copy & ...
|
| Link Page Fields to separate Pivot Tables | 24 Feb 2006 18:42 GMT | 2 |
Is it possible to link the page fields for two different Pivot Tables so that when one page field is changed it updates the other also? I'm sure this is a common question(I did try and search!) and the solution is probably simple but I cannot seem to get it.
|
| obtaining data from a list | 24 Feb 2006 17:36 GMT | 1 |
I need to get some values from a list but I don't want to sort or filte the list. I want a user in input some values and I want to obtain value in the list based on what was entered. Then I want to use tha value in other calculations. Also the list is formatted like this:
|
| SUMIF function | 24 Feb 2006 17:08 GMT | 14 |
Hi, please help... I am trying to total up commission figures in a column that match a specific year. Each row contains a cell for the date it was entered, the customer details and commission earnt.
|
| Compare two worksheets | 24 Feb 2006 17:01 GMT | 5 |
Hello everybody! I need to know how to compare two worksheets. I do not know anything about Excel. I need to know how to generate the differences into a new worksheet. Any help would be appreciated. Thank you.
|
| Why won't the number 9 enter as that and gets replaced with 0 ins | 24 Feb 2006 16:57 GMT | 2 |
I am entering9 to 16 digit actual account numbers and every time I use a 9 it gets replaced with a 0. WHY? and what do I have to do to get it be what I entered?
|
| Dynamically creating entries in worksheets | 24 Feb 2006 16:12 GMT | 15 |
Is it possible to dynamically create entries in a worksheet based on th entry in another worksheet? If so, can you point me in the righ direction. Thanks in advance
|
| nested if statements - need help | 24 Feb 2006 16:06 GMT | 9 |
Not sure if anyone can help me with this I have 2 sets of criteria.. and I'd like a formula that checks 2 cells and then calculates a result based on the criteria of those 2 cells. i'll try my best to explain.
|
| how do make a row non numbered? | 24 Feb 2006 15:37 GMT | 2 |
Trying to make a row not have a numbered value on the left side.
|
| If formula nesting | 24 Feb 2006 14:22 GMT | 3 |
Does any one know if there is a limited number of arguments one can nest in an IF formula? I have tried entering 14 conditions and it will not accept after the 8th one. It tells me I have no false value. Or is there something wrong with my formula?
|
| uploading excel floppy file onto microsoft works | 24 Feb 2006 14:00 GMT | 2 |
Have a new computer. Saved data onto a floppy disc from my old computer. Trying to download this information onto new computer but as new computer does not have microsoft excel, it wont let me. Can I get around this somehow. ??
|
| Protect to view VBE in Excel | 24 Feb 2006 13:28 GMT | 1 |
I have a protected workbook. I wnat to protect to view VBE with password. How it can be. Thanks Rao Ratan Singh
|
| Can I use Excel to create a form? | 24 Feb 2006 12:13 GMT | 2 |
Hi, Is it possible to make a form by Excel? I need creat a form which will need users fill some information such as Name _____
|