| Thread | Last Post | Replies |
|
| merging workbooks | 06 Dec 2007 15:57 GMT | 3 |
Hello, I have Excel 2007 I have 3 workbooks that I want to merge into a single workbook, with each of the originals on a different sheet. I know how to open a clean sheet, but cannot find out how to import the original workbooks into them.
|
| Deleting shortcut key In Recording new Macros dialog box | 06 Dec 2007 15:41 GMT | 1 |
I have recorded several new Macros and I am running out of shortcut key letters to put into the shortcut key box within the Record a new Macro dialog box. How could I delete the shortcut keys that I have already used to reuse again to record new Macros?
|
| Compare and Highlight Rows | 06 Dec 2007 15:26 GMT | 12 |
I have an excel file with two worksheets. is there a way to programatically compare the two worksheets to find matches and highlight those matches on each worksheet. They both have the same columns.
|
| Read displayed, rather than raw, date | 06 Dec 2007 13:54 GMT | 8 |
I have a row of months which, for ease, I have allowed Excel to interpret as dates. The month is displayed as e.g. "Dec-07" but the 'raw' data in the cell is e.g. "01/12/07". For reasons that are not important here, I need to be able to perform conditional functions
|
| Currency problem with SFr. | 06 Dec 2007 13:04 GMT | 2 |
Hi All, odd problem this one. One of my users is updating an existing spreadsheet. We use Office 2003 with SP3. He has a list of figures (5 off) all set to different currency's, one of which is £ (british pound). However, all is fine
|
| how to find data and list all of them in a cell. | 06 Dec 2007 13:03 GMT | 1 |
I have one database table like this. ============================== Col_A Col_B Col_C name room cancel
|
| count function | 06 Dec 2007 12:56 GMT | 1 |
How to count in Excel with 2 or more arguments Somthing like this =Countif (a2:a200 = "A" and B2:B200="B") Please Advise
|
| Date format in Indian style | 06 Dec 2007 12:46 GMT | 1 |
I am trying to get the date format in Indian style... That is dd-mmm-yy. I am unable to set my excel to do that. It always asks me to enter mm-dd-yy. Kindly help L Krishna Kumar
|
| Get Excel to provide equation for my x and y | 06 Dec 2007 12:01 GMT | 2 |
I am doing an assignment on how hot water gets in degrees celcius when so many kilojoules are supplied to it. i have a graph, with data provided to me for this function. kilojoules is my y, and degrees celcius is my x. i need to get excel to provide an equation that relates heat, ...
|
| Date/Time entry | 06 Dec 2007 11:53 GMT | 4 |
Where a cell is formatted for date / time ( yyyy-mm-dd hh-mm) is there a shortcut keystroke(s) that will insert system time in that cell. Thanks in advance teabag
|
| CALCULATING DATES | 06 Dec 2007 11:40 GMT | 3 |
can anyone help me! i have created a gantt chart, but having the following problem: column A contains qty of days, column B is start date, column C is end date. i have set column C so that it adds column A + column B to give me an end date, but if there is no start date, the end ...
|
| Saving custom colours? | 06 Dec 2007 09:05 GMT | 3 |
When you choose a custom colour via Tools->Options->Color and make it available in that particular workbook by modifying one of the standard colours to the chosen colour - Is there any way of making those colour modifications permanent so that those new colours are available in ...
|
| xlodbc.xla - Excel ODBC Add-In - Where is it for Office 2003/2007? | 06 Dec 2007 05:40 GMT | 3 |
I am trying to run SQL queries directly from a worksheet in Excel. I have found an add-in for Excel 2002 that is no longer supported in 2003 or 2007 which is just what I want (xlodbc.xla). 1. Why was this discontinued?
|
| extract data from middle / right of string | 06 Dec 2007 04:39 GMT | 11 |
I have a column in a spreadsheet containing the following type of string: 330189149967 Ideal - Series 2 (DVD) 3 12.99 GBP 38.97 GBP I would like to extract the number after the (DVD) in this string.
|
| excel opens but not the document | 06 Dec 2007 04:31 GMT | 2 |
i have a problem with excel 2003 - when i click on an excel document excel opens but does not load the document - i have to go to file >> open to open the document any idea's would be appreciated
|