| Thread | Last Post | Replies |
|
| Help! | 05 Mar 2006 02:39 GMT | 2 |
Was wondering if there was a way to and if anybody knew how to do the following: I have a pick from list in Cell A2 and when Cell A2 has the data fromA3 then cell B2 needs to have the data in B3 and so forth for about 10
|
| Why do the colors or shading only show up in print preview in Exce | 05 Mar 2006 00:11 GMT | 2 |
I have attempted to follow directions for inserting color and shading in cells in Excel, but the color only shows in print preview, not in the window I am working in.........WHY is this happening?
|
| increment a value by 1 | 04 Mar 2006 23:06 GMT | 3 |
How do I increment, automatically, a cell by 1 if a condition is met? If one of my cells reaches 10k I want another cell to increment by 1. Can anyone help me if this function can be done? Thank you, Ron
|
| Erase data, preserve formula's | 04 Mar 2006 21:24 GMT | 3 |
I have a an excel file with 12 worksheets for the financial year and an additional worksheet for yearly totals. I need to get a blank copy of this and was wondering if anyone knew a way to delete all the user inputted data while keeping the formatting
|
| Lookup | 04 Mar 2006 19:55 GMT | 6 |
I have to two worksheet in the workbook, the first is the data that will have this columns date, time, nmbcalled, cost and duration and another worksheet will have name and number. Worksheet 1
|
| Sort name from specified interval table | 04 Mar 2006 19:54 GMT | 4 |
Hiiii I am facing a silly problem i think u guys are rescue me from that... My prob like I have two cloum one colum contain Name of person and another coloum contain their salary.I prepared a interval table contain
|
| Saving a Macro | 04 Mar 2006 19:35 GMT | 5 |
I have a Macro that I want to save and have available as a general tool I can use on any file that I open. I am using Record New Macro to generate the macro and it works fine in the file that I had open when I recorded the file. But when I open a new blank
|
| Is there something like an "If, then" formula? | 04 Mar 2006 19:26 GMT | 4 |
I am trying to set up a time card that I downloaded from the templates page on MS. I like the format of the one that I have, but this is what I want it to do: Currently it is set up to calculate time for the week as streight time, i.e.
|
| addition | 04 Mar 2006 18:40 GMT | 1 |
When I change a number in one of the cells the result won't change when I click "enter'". (this is in addition)
|
| Combine Sheet Data | 04 Mar 2006 17:23 GMT | 6 |
Need help with a macro. I have a work book with two sheets. Both sheets have the same layout and are sorted by column A, by part number. The only main difference is sheet two has one extra column which is a UPC code. I need to be able to take this column and add it to sheet one ...
|
| finding last and creating average amount income to date | 04 Mar 2006 17:01 GMT | 1 |
In col B are dates in col F are the amounts paid. in A1 I want to create the average months income. Generating the avearge using the part of the month not just an entire month. If I am at 10 days into a month or 20 days etc. the average will reflect
|
| Finding age from year | 04 Mar 2006 15:51 GMT | 4 |
I have a SS that has a column for YOB (year of birth) and would like to generate a column with which to chart age distributions. What's the best functions to find AGE from YOB and current date? -dude
|
| Sort Rows Ignoring Headers | 04 Mar 2006 15:14 GMT | 5 |
I have several pages of data in rows. Each page has the same column headers for use when printing out just that page. I want to be able to sort all the rows on all the pages as a single sort without getting the headers involved. How do I lock out the headers from the sort?
|
| Double-click a cell containing a formula | 04 Mar 2006 13:56 GMT | 6 |
When a cell containing a formula is double-clicked, normal behaviour is that the selection moves to the cell whose reference is the (first) argument in the formula, even if it is on another sheet. If the sheet containing the formula is fully protected, one would expect this ...
|
| importing data | 04 Mar 2006 12:35 GMT | 4 |
I have a text file, which consists of one integer per line. Is is possible (easily) to import this into excel 2k3 so i can produce a graph of it? Thanks
|