| Thread | Last Post | Replies |
|
| Keyboard Shortcut | 15 Jun 2007 15:09 GMT | 1 |
hi. is there a keyboard shortcut to adjust the row or column width?
|
| Autoexecute macro | 15 Jun 2007 15:09 GMT | 3 |
What I need it this, As soon as a user opens a specific file, the macro ( in vba), creates another worksheet, inserts 3 columns and makes the first column auto numbered. I am sure this isn't hard. But I am a "newbie" to this.
|
| organizing series data 34 items | 15 Jun 2007 15:04 GMT | 4 |
I've created a 2 axis line chart that tracks 17 locations in sales and traffic. I want to keep the sales and traffic series for each location together in the legend. I cannot keep them together they keep seperating into 1- 17 sales and 1-17 traffic. the organize series option ...
|
| prevent schientific notation | 15 Jun 2007 14:45 GMT | 1 |
I have a vb program that takes a skeleton xls file with a few rows of headers and an sql command to obtaiin data, and then populates the spreadsheet. The number of rows and columns varies as does the type of data in each row.
|
| How do I format a figure as cent (e.g. 0.015 displayed as 1.15) | 15 Jun 2007 14:41 GMT | 1 |
I would like to format number expressed in Euro (same with Dollars) in cent. e.g. instead of having "0.0123 €" I would like to see "1.23 ct" Using percentage symbol I get the right figures but with the wrong symbol: format: "0.00 %" -->> figure is displayed as "1.23 %"
|
| macro code to get dynamic range | 15 Jun 2007 14:41 GMT | 3 |
Hi Friends, I am trying to write a macro to find if a range consists of same values or not Eg
|
| how do I transfer data from one sheet to another with VB code | 15 Jun 2007 13:40 GMT | 2 |
I am a novice when it comes to programming. I am trying to make a simple accounting systems. I would like to: Fill in data on one sheet run a macro
|
| copying formulas | 15 Jun 2007 13:34 GMT | 7 |
I'm a self-taught Excel user (semi-intermediate level), although I'm having a "formula" problem: When I copy the "value" of a cell from cell A (which contains a formula)…. And paste special to cell B (for value only)…. I don't want the contents in
|
| future value | 15 Jun 2007 13:12 GMT | 1 |
I am getting a negative return on my answer. The question was, I have a PV now of £10,500.00 Leaving in as an investment for 15 years Interest rate per anum 5%
|
| Using "Countif" in macro gives compile error | 15 Jun 2007 12:23 GMT | 4 |
Hi to all, I dont know why following line of code in my macro is giving a compile error Single line Code >>>
|
| Currency format in visual basic text box | 15 Jun 2007 11:47 GMT | 2 |
This is probably a very silly questiong but i can't find how to solve it. I have made a form that you enter in data and it puts it into cells on a spreadsheet, some of it is a numerical amount. These amounts are then referred to in other formulas. Despite the cells being in the ...
|
| possible to calculate % attainment using one formula? | 15 Jun 2007 11:07 GMT | 6 |
I need to measure one set of data over the other. For example, Set A is forecast and Set B is actuals. Set A 591 107 (160) (559) (159) Set B 362 (24) 50 (121) (295)
|
| Healing/recompiling corrupted Excel files? | 15 Jun 2007 11:00 GMT | 2 |
I have an Excel file that I suspect has some element of corruption associated with the file. It basically a data processor I have been developing intended for general use that accepts in data and manipulates it with prodigious use of formulas, pivot tables, macros
|
| Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file? | 15 Jun 2007 10:42 GMT | 4 |
Every time Ia file is closed in Excel 2007, the program asks if I want to save any changes made to the file, even if the file was not modified. This happens even if just viewing an excel attachment in Outlook.
|
| Dates don't appear properly after downloading data from Accounting | 15 Jun 2007 10:18 GMT | 4 |
I have a report in an accounting program called MYOB. I chose to export the report to Excel 2003. However, Excel shows the dates (found under one column) in two different formats. i.e. some of the dates appear in this format (04-April-2007), while others appear in another format ...
|