| Thread | Last Post | Replies |
|
| Data Validation Work Around | 26 Apr 2008 03:55 GMT | 3 |
Is there a work around to creating lists on wroksheets from other worksheets. I would like to have one worksheet with all my reference lists and data on it.
|
| Install Excel on a new computer | 26 Apr 2008 03:10 GMT | 6 |
I'd like to have all the same customized tool bars, Personal file, add ins, etc. on my new computer that I have on an old computer. What files do I need to copy over and where do I find them? I can't even remember all the settings and changes I've made since my original ...
|
| need template for weekly church contribution sourcesand attendanc | 26 Apr 2008 02:59 GMT | 1 |
I need a template for my desktop that I can fill in each week with the number of attenders and different sources of contributions per service.
|
| finding more than one item | 26 Apr 2008 02:30 GMT | 1 |
I have a list of about ten items I am searching for in my spreadsheet. I am using find & replace. Is there some way that I can find more than one item at a time? Can I seperate them with a symbol of some sort that will find them all instead of having to find each one ...
|
| Enter doesn’t return to the cell below the starting point anymor e | 26 Apr 2008 02:19 GMT | 3 |
This just started happening yesterday... My documents are protected as "Select unlocked cells", which is how I’ve always protected my documents. By the way, I’m using Excel 2003. Anyway, when I hit enter after tabbing through cells it doesn’t return to
|
| Rate of Failure Formula | 26 Apr 2008 02:16 GMT | 3 |
Here is the general concept. I have 56 Televisions. The month is currently april and 3 of those 56 have failed(quit, don't work). I am wanting to try and find a quick and easy formula that gives me the rate of failure. I know it is probably something
|
| Changes not saved | 26 Apr 2008 01:45 GMT | 3 |
I am by no means an Excel expert, however, I am very comfortable with all the basic functions of Excel. From time to time, I've noticed that after opening an Excel file, working in it, saving, closing, opening it, performing a Save As, etc. that there are times it does not save ...
|
| binary format | 26 Apr 2008 01:09 GMT | 2 |
Is there any benifit to using binary format for your workbooks? does it support macros? work fine with addins?
|
| How can I list every data combination from a large pivot table? | 26 Apr 2008 00:59 GMT | 1 |
I've got 125 line items (text) I need to multiply out and show every combination in 2 columns (15625 possible line item combinations). In addition, I will need to run formulas for each row so Merged Cells do not work. My closest attempt with reference data arrays and lookup ...
|
| Excel 2002 Pivot Table: Can I copy link cell across ? | 26 Apr 2008 00:34 GMT | 2 |
Dear Sir, I use pivot table to summarized large data quite frequently. At times I need to extract data from the pivot table into the formats of my own by linking cells.
|
| File Size With Macros Has Increased From Its Origina Size | 26 Apr 2008 00:24 GMT | 1 |
I have a spreadsheet with a few macros that I open and execute about several times a day for the past year. I noticed that the file size increased from less than 100 bytes to 5 MB. There has been no increase in the cells and/or macros.
|
| Does manual recalc attach to a worksheet | 26 Apr 2008 00:08 GMT | 1 |
when setting options to manual recalc - are those options saved with the worksheet? if another user opens the worksheet, will the cacluation options be based upon the worksheet, or upon that user's machine options? thanks in advance
|
| Font color dipicts which formula to use | 25 Apr 2008 23:48 GMT | 2 |
Is there a way in Excel to have two different formulas and if the number in the cell color in black it uses one formula and if the color of the number in the cell is red it uses a different formula? Example:
|
| Spreadsheet to assist new car purchase | 25 Apr 2008 23:35 GMT | 1 |
Seeking a spreadsheet that would help in the comparision of new cars as my family considers a purchase. It would compare important features and options and prices. Thanks
|
| vb code question | 25 Apr 2008 22:43 GMT | 8 |
I have 15 minute interval data in column A and through vb code I need to select the data in column B and have it moved to match the cooresponding row in column A. In other words, if there isn't an interval of 6:15 in column B then I want to leave that row blank. In the example ...
|