| Thread | Last Post | Replies |
|
| arranging windows | 28 Jul 2006 21:36 GMT | 2 |
Can the worksheets in a given workbook be arranged vertically?
|
| We're Talking Basic (I think) | 28 Jul 2006 20:59 GMT | 2 |
I am creating a price list. BIG. I want to be able to go into the price list and apply a percentage increase throughout every cell that has a dollar value. :rolleyes: Change the prices by th percent desired, drag and drop into a layout, print and send t
|
| auto copy old data to new cell | 28 Jul 2006 20:11 GMT | 1 |
How does one automate the copying of old data in cell A to cell B when new data is entered in cell A?
|
| Stable formula | 28 Jul 2006 20:06 GMT | 3 |
Let say I have this formula, =SUMIF('TSJ Student List'!C3:C118,"=4",'TSJ Student List'!A3:A118) My question is how can I use only rows C3:C118 and A3:A118 and the only changes is "=4" to 5,6 ....because when I copy or drag it will change to
|
| Subscript out of range Error? | 28 Jul 2006 17:21 GMT | 2 |
I keep getting a subscript out of range error with this macro. Any help would be great. Public Sub AddSheetToEnd() 'Create a new sheet
|
| Links to multiple Checkboxes | 28 Jul 2006 16:50 GMT | 2 |
I'm trying to link a range of cells that include checkboxes to an adjacent column, but i dont want to go into each cell and link them seperatley. Is there an easier way to do this? Ex.:
|
| Search and replace problem | 28 Jul 2006 16:14 GMT | 2 |
I have an Excel worksheets where in several cell's a symbol was added to mark the cell's "to review". The symbol used was "(*)". I have tried now to delete all the entries with a "search and replace", but
|
| Can you use formulas in conditional formatting or do I think diff. | 28 Jul 2006 16:05 GMT | 4 |
I have a spreadsheet with names and dates. They want a date to turn color or do something when the date hits 3 years old. So if I did something on 1.1.04 they want it to indicate expired when 1.1.07 hits. Any suggestions would be greatly appreciated.
|
| Automatic navigation based on cell text value | 28 Jul 2006 14:42 GMT | 2 |
I am creating a budget spreadsheet and wish to have a macro run automatically and navigate to a specific cell of a different worksheet based on a determined value of a cell. For example, Cell A5 in the MAIN worksheet uses a drop down list from a
|
| Question about a formula (Excel XP) | 28 Jul 2006 14:17 GMT | 4 |
I'm "dissecting" a budget to better understand and (hopefully) put it to use for our oreganization. I ran across this formula is a cell: =IF($B$13-'Cash Budget'!C37<0,0,(($B$13-'Cash Budget'!C37+'Cash Budget'!C38)*'Unrestricted Revenue'!$B$9/12))
|
| I'm having problems understanding the formulas in Excel | 28 Jul 2006 14:06 GMT | 2 |
Learning Excel, and having problems with the formulas.
|
| Covert text to time | 28 Jul 2006 13:25 GMT | 8 |
Hey, I am unable to convert a piece of text to the time format. I am copying this from an external source. Example, "July 24 2006, 05:31 PM" Excel does not convert it to the date format. Please help. Please see
|
| Help please, error in compilation | 28 Jul 2006 13:11 GMT | 1 |
When I start Excel appears a windows indicating a compilation error in a hide module (mdlXlTrans) ith only the option accept, after, that the program start and work normaly. When I close it, the same thing, the window and so on .
|
| Borders not allowed | 28 Jul 2006 13:09 GMT | 3 |
For some reason I have opened a spreadsheet that was sent to me and I cannot put a border on any cells. I am able to edit all cells and there does no appear to be any protection.
|
| Excel strips "s from CSV and inserts 0D0As ... | 28 Jul 2006 11:51 GMT | 3 |
I use Excel to open a *.csv file that looks as follows in an ASCII Editor ... "A-XXX-123","A" "A-XXX-1234","A
|