| Thread | Last Post | Replies |
|
| Adding a loop to conditional delete code | 15 Aug 2006 16:11 GMT | 21 |
I have the following code: Sub DelOver16() If ActiveCell.Value >= 16 Then ActiveCell.EntireRow.Delete End Sub
|
| Excel chart with two x-axes | 15 Aug 2006 13:15 GMT | 2 |
I would like to draw a chart with one y-axis and two x-axes. Please can someone point me in the right direction?
:) |
| No Color Palette, ActiveX | 15 Aug 2006 13:10 GMT | 1 |
I have placed a CommandButton on a worksheet from the "Control ToolBox" tool bar. When I right click on the CommandButtom and select "Properties" and get the properties Dialog box to appear. I next select "BackColor" , so I can change the background color of the CommandButton. ...
|
| Basic hours * rate formula | 15 Aug 2006 12:52 GMT | 1 |
Sorry for this lame post..... I've a cell showing the amount of hours spent on a project (68:45:00). My hourly rate is $ 105 How do I convert the hours into a number which I can then multiply with 105
|
| cannot scrol on huge spreadsheet - urgent | 15 Aug 2006 12:20 GMT | 2 |
i have excel 2003. some of our staff is working on a membership database. all this info is in a spreadsheet. it is lots of info. thousands of records. there is custom filters in the different columns. lets say they choose CTE from the drop-down list than all the CTE records ...
|
| Vlookup | 15 Aug 2006 12:13 GMT | 6 |
I have a vlookup sheet,I want to add notes to the cells in the vlookup table,but when i get the information from the vlookup table to another sheet the notes will not go over with the information .CAN ANYONE HELP. P.S I hope i have explained this correctly.
|
| Abridging lists of numbers | 15 Aug 2006 12:09 GMT | 2 |
I've a very long range of numbers that I desperately need to condense into a list that contains only ranges and single numbers, e.g. 1-5,6,8,11-32,35,40 Please help me out guys - the list is ridiculously long, and will take days to do manually!!
|
| How to know if a cell is in a range? | 15 Aug 2006 10:53 GMT | 2 |
I need to know if the cell D9 is in the range A7 - E20 Thanks
|
| Worksheets Inheriting Contents | 15 Aug 2006 09:26 GMT | 2 |
I'm currently working on creating a set of specifications using Excel These specifications are contained within a single Excel spreadshee which contain multiple worksheets, each relating to a different aspec of the form (say calculations, form rules, dependencies). The proble
|
| Customization of paper size..... | 15 Aug 2006 09:01 GMT | 1 |
Hi goodmorning Everyone! hope someone can help me...i am trying to figure out if i can customize the paper size options in the page set up? is it possible? I am working right now with a continous paper with 5 x 8 inches measurement (portrait orientation)....thanks in advance!!!
|
| Re: how to add one same word on every 10th line | 15 Aug 2006 08:54 GMT | 2 |
i have excel with 50000 lines.i have to insert this word "###break###" on every 10 th line.how to do this? i tried macro but cannot able to do.i need help.advance thanks for you help
|
| validation does not work | 15 Aug 2006 07:40 GMT | 2 |
If I input cell's value with VBA codes, the validation rules contained in the cell would probably not work, are there any other ways to make the validation works when I set its value outside the sheet? Thanks,
|
| Array Formula Help -IF / Else clause? | 15 Aug 2006 07:25 GMT | 4 |
I'm just getting to grips with Array formulae, and one of the formula I use most frequently is to count combinations of values over two arrays: For example: =SUM(IF(A1:A100="Ford",IF(B1:B100="Focus"1,0)))
|
| Data from multiple sheets and workbooks | 15 Aug 2006 06:51 GMT | 3 |
Each week I receive a workbook from one of my customers. It contains mutliple sheets with salesnumbers from all the branch of my customer. Each sheet contains from 1 000 to 15 000 lines of salesdata. Every article sold gets one line in the sheets.
|
| Hiding a cell from printing in Excel 2003 | 15 Aug 2006 05:47 GMT | 2 |
Is it possible to hide selected cells within a workbook from printing in Excel 2003 and how can this be done? Regards Nevio
|