| Thread | Last Post | Replies |
|
| Dynamic sum in Chart | 18 Aug 2006 02:53 GMT | 1 |
So I've got this pivot chart that I've created, and it's great, EXCEPT when I select different categories to show up, I want to show a SUM of the categories, not the values of each category. I would appreciate any help/advice you may have.
|
| Help me with this please... Urgent.. | 18 Aug 2006 02:48 GMT | 1 |
I have this record ---------------------------------------------- Code | File | ----------------------------------------------
|
| Can you write-protect one cell at a time? | 18 Aug 2006 00:51 GMT | 2 |
Is it possible to write-protect ONE cell at a time? Thank you An --
|
| Estimating return on investment | 18 Aug 2006 00:41 GMT | 1 |
Does anyone have a decent template for estimating the ROI for a new software project? I'm afraid I'm in a bit over my head. Many thanks in advance, John Duke
|
| How do i set up check boxes in excel? | 17 Aug 2006 23:59 GMT | 1 |
I am really green at excel and I do not have a book to find answers in. I have tried the help feature but I seem to be getting no where. Can someone please help me? I am trying to set-up check boxes that will allow us to select a edge profile for counter tops that will then appear ...
|
| Autofilter | 17 Aug 2006 23:12 GMT | 3 |
The autofilter is excluding cells that contain data with 5 characters or less. It doesn't matter if the data is a number or text. I checked Tools, Options and there does not appear to be anything there that limits the filter tool. Anyone have a suggestion to correct this?
|
| Cascading drop down filter | 17 Aug 2006 22:21 GMT | 2 |
When applying several filters I haven't found a way to make the dropdowns show only the options left available after I have chosen a filter on another dropdown. I mean like the autofilter functions works. When you filter one dropdown the others still show all options, even those ...
|
| how do I stop the cell from filling automatically? | 17 Aug 2006 21:42 GMT | 1 |
I am trying to fill in scores from a golf match in an excel spread. When I try to enter individual scores I get the # sign for some of the numbers. This seems to be happening in only one column, so I must have something turned on to make this happen. It's not happening in ...
|
| Pasting into Word????? | 17 Aug 2006 21:07 GMT | 4 |
Does anyone have a suggestion or recommendation as to how I can cut a piece of some data in EXCEL (without gridlines), and paste it into MSWORD and not have the gridlines appear? Thanks, in advance Mike
|
| Rows are hiden in normal view but not printing view | 17 Aug 2006 21:05 GMT | 1 |
:confused: I have some how "hidden" my rows in "normal" and "page break preview". But they will show in "print preview" and print the rows. Can you please help me get them back. :eek: Ann
|
| Multiple Hyperlinks in 1 cell? | 17 Aug 2006 20:45 GMT | 3 |
I have some spreadsheets that have a column with some text (4 numbers) that link to a webpage, where the URL ends with the four numbers (eg.1234). Sometimes I place an additional 4-number reference to another Webpage
|
| Email Formula | 17 Aug 2006 19:11 GMT | 1 |
I was wondering if it is possible to put a formula in a cell that will send a reminder email on a specified date?
|
| List of currency codes - are they are all the same? | 17 Aug 2006 18:40 GMT | 2 |
I am working on aggregating revenue based on currency. Typically I convert everything to USD for my aggregates, but I now have a request from my users to aggregate on local currency whenever possible. I have worked out how to do this in my tool, but am looking for a way to
|
| Excel application.quit in macro problem | 17 Aug 2006 18:36 GMT | 3 |
I've created a macro that begins with an auto_open importing, reformatting, and saving data. In the same macro, I have an open excel form. Next, Im attempting to application.quit the excel wb because it isnt needed. When I enter a simple application quite before end sub, 30
|
| comparing a number to a list of numbers | 17 Aug 2006 18:32 GMT | 4 |
I have a column of numbers and a single number in a seperate cell. I would like to know what functions I could use where I compare th single number to the column of numbers and return that number whic closest.
|