| Thread | Last Post | Replies |
|
| Disabling Cut and Copy | 21 Aug 2008 15:12 GMT | 14 |
Is it possible to disable cut and copy functions in Excel through VBA codes? If yes could somebody show the codes please? Thank You. M Varnendra
|
| salary tax calculation f | 21 Aug 2008 14:59 GMT | 2 |
How can i calculate progressive tax. For example if all income up to 200$ is exempted from any tax and : $ 201-500 taxed 10% 501-1000 taxed 15%
|
| Formulas in drop down lists | 21 Aug 2008 14:58 GMT | 11 |
is it possible to include a formula in a drop down list and make the value that appears in the drop down list dependent on de row/column your in. To be more precise: I'm doing a study and have a list of people with different birth dates. One column is "age". I can calculate this ...
|
| Vba - Picture Object naming | 21 Aug 2008 14:11 GMT | 2 |
I have a macro that copy's a range in the workbook to a picture. 1.) Copy's a range and saves as a picture What I want to do - rename the picture object. I think it is named "Picture 1" or "Picture X" by default, but this is no good since I want to refer to it
|
| Automatically go to another cell | 21 Aug 2008 14:08 GMT | 1 |
Can cell a1 have a go to command sending cursor/selection to b11 when a1 is clicked on? Or can shortcut keys (ctrl,home) be set to stop in b11 instead of a1?
|
| excel 2007 problem | 21 Aug 2008 12:58 GMT | 1 |
I have an excel 2003 file and I can not open it. When I open this file, there is a message that: "one or more invalid names were detected in this workbook. Those invalid names have been changed to #REF!"
|
| If a cell contains "preferred" then do this | 21 Aug 2008 12:22 GMT | 3 |
here is what I got =if(a1="*preferred*","B","A") what do I do to make it work? thanks... Steve trying to match partial text in a cell
|
| Short cut key for 'address' line | 21 Aug 2008 11:48 GMT | 3 |
Is there a short cut key available for getting to the 'address' line in Excel? Don't know what's it's called but it's the line where cell input also appears (next to fx). I know in Internet Explorer the short cut key is F6, but that doesn't seem to be the one in Excel.
|
| Polynomial Curve Fit | 21 Aug 2008 11:08 GMT | 3 |
I'm trying to do a polynomial curve fit (order 2) for the data below, but the equation that the curve fit provides is way off. Any ideas why this isn't working? It works for a similar set of data... x y
|
| how to insert same row numbers in several function statement | 21 Aug 2008 11:05 GMT | 1 |
I am doing data processing without using macro...because data formats are so random. My qustion is about how to insert same row numbers in the several function statement even though the colums are different. My function statements are as
|
| protecting the cells | 21 Aug 2008 11:04 GMT | 1 |
Dear Support How can i protect the cells with formulas so that no one can alter. Plesae help a.s.a.p.
|
| Removing hh:mm:ss from date | 21 Aug 2008 10:58 GMT | 3 |
How can i remove the hh:mm:ss from the end of a date? I've converted it to just date, and it looks as its just date but if you click on the cell you can still see the time. I want to be able to group a list by date only and cannot get ride of the time extension.
|
| Date Count ! | 21 Aug 2008 10:51 GMT | 7 |
In a spread sheet i have dates in col A and Col B (start date and end date). Col A Col B Dates Count Status 01-jan-08 10-jan-08 10 days Completed
|
| Need help in round up or down price to specific ending number | 21 Aug 2008 08:59 GMT | 2 |
Can anyone help me? I doing the price, there is two processes, first I have to calculate the USD to my country's currency then I have to round up or down the price. I need the price end with 500, 700, or 900 without decimal. The way to round the price is like this.
|
| How to pick out unique components in a list with unique and common | 21 Aug 2008 08:45 GMT | 4 |
I want to pick out unique components in a cell which has both unique and common components. My data list is as follows. 514/406 514/326
|