| Thread | Last Post | Replies |
|
| How To Copy Conditional Formatting to Several (1,000) Cells | 30 Apr 2006 22:26 GMT | 2 |
I get the whole Conditional Formatting thing, so I'm not looking for a tutorial. However, I can not figure this one out. What I need, is an individual row to be highlighted a certain color, depending on the content of one of its cells. Sounds easy enough right, well, I need to ...
|
| convet to an .exe file | 30 Apr 2006 22:20 GMT | 8 |
I have a spreadsheet workbook that i would like to convert to an .exe file, so it acts as a standalone application. Not all my target users will have excel installed, so i need a way to distribute the workbook so all can use it.
|
| Number/text formats | 30 Apr 2006 22:11 GMT | 1 |
I need some help to get a Number format in Excelsheets. I work with artikel numbers in the format 00.0000/0 When I try to get this format in the user formats doesn't this work I become I this format working, example:
|
| Excel/VBA possibilities | 30 Apr 2006 21:18 GMT | 2 |
I have a question about the possibilities of Excel (in combination with VBA). Someone asks me to solve a problem and gives an idea for a possible solution along with it.
|
| invoking a macro | 30 Apr 2006 19:46 GMT | 1 |
Is it possible to invoke a macro when starting excell fom the command line? My ultimate purpose is to permit a user to push a button in my app and invoke excel which then imports a CSV text file which my app has generated. Any alternative approaches?
|
| Can't see ANY color in Excel | 30 Apr 2006 19:11 GMT | 1 |
I am "refurbing" a laptop to give to another user in my company. My problem is that I cannot see any color in Excel, I cannot fill a cell, and when I am typing in a color it turns to black when clicking on another cell. The actual display is fine as I can see color in any other ...
|
| fixing corrupted files in xls format | 30 Apr 2006 19:08 GMT | 1 |
Hello, I have several files that became corrupt after moving them from 1 drive to another during a reinstall of windows. I am using windows xp pro and office 2003 pro. There are also several files that do not appear to be corrupt but insist that I download and use windows rights ...
|
| **Import file to Excel** | 30 Apr 2006 19:05 GMT | 1 |
How can I have an autocad file imported in Excel enviroment? Autocad file has some text and pictures which it's enough for me to have its text imported. How is it possible?
|
| fix old file created with an old version of excel | 30 Apr 2006 18:44 GMT | 2 |
I have a workbook that I have inherited from a previous employee. I believe that it was created with an old version of Excel, or even with Lotus 123. Basically, I have a few sheets containing what seems to be the code for macros (they in fact appear under the tools>macro>macros
|
| how to find links/references? | 30 Apr 2006 18:27 GMT | 2 |
I have multiple excel files with 50plus worksheets. I am looking for a way to find those worksheets, that are SOURCES for links (hope I use the right terminology, I mean to find numbers on each worksheet that are refered to on other worksheets in the same xls file). I would also
|
| Create Pivot Table with 2 different Data source | 30 Apr 2006 14:48 GMT | 1 |
Data Source 'A': Customer monthly sales Data fields: Cust_name, Apr 05, May 05, Jun 05, Jul 05 Data Source 'B': Customer Info Data fields: Cust_name, Cust_ID, Cust_Group_ID
|
| What does the Below mean | 30 Apr 2006 13:40 GMT | 3 |
Hi all would greatly appreciate any form of help on the below. It's in one of my spreadsheets & am trying to work it out. Currently the sheet States March thou on the address bar it's got the below Formula. I don't now what it means & i'd like to change March into April. There is
|
| cell conditioning | 30 Apr 2006 11:32 GMT | 1 |
basically im very new to excell and im trying to create a sales shee for my company (tesco) on store performance and at the moment iv conditioned the cells so that when the LFL targe sales are down the cell goes red eg.
|
| sum if wildcard | 30 Apr 2006 11:25 GMT | 1 |
Hi, im trying to sum data based on data in another cell and need to incorporate a wildcard character. My formula is =SUM(IF($G$2:$G$52997=BA2,$M$2:$M$52997,0)) I need to use the asterix (*) wildcard with the cell BA2.
|
| Numbers to Words | 30 Apr 2006 08:46 GMT | 2 |
I'm looking for a macro/VB script for expressing an amount in pesos in words, in Spanish - anyone got a script kicking about? Thanks, Thomas.
|