| Thread | Last Post | Replies |
|
| Auto copy single values to another cell | 27 Sep 2007 14:11 GMT | 5 |
Hi to all, I will thanks if some help can be provided. I have a list of items that contains repeated items in column A (each week i start a new file with the empty list). I would like in column C to appear automaticaly
|
| Need help with cell format custom | 27 Sep 2007 13:51 GMT | 4 |
I have a worksheet that list my magazine collection and I am having problems with the cell formats. In my shopping cart program I had entered many of the product titles and when exported as a cvs the titles exported fine and were listed as a General Format.
|
| Closing a workbook exits Excel Application | 27 Sep 2007 13:51 GMT | 2 |
When I close a workbook the application closes also. Is there a way to keep Excel open and close a workbook. This started happening after an upgrade to 2007.
|
| Writing Macros - Dummy Guide | 27 Sep 2007 13:49 GMT | 1 |
Hi I want to write a macro to take information from approx 3/4 spreadsheets and input into one other. I also want to schedule this as a task to run daily/weekly.
|
| Word table to Excel | 27 Sep 2007 13:40 GMT | 1 |
I have a word table that I need to put into Excel, however when I bring it into Excel the formatting of the dates goes out of kilt. In word the dates are Thu 13th Sep 07 and also the address and name give me issues too. I am sure its to do with the fact that as they are in
|
| Converting a word table into excel | 27 Sep 2007 13:39 GMT | 2 |
I have a word table that I need to put into Excel, however when I bring it into Excel the formatting of the dates goes out of kilt. In word the dates are Thu 13th Sep 07 and also the address and name give me issues too. I am sure its to do with the fact that as they are in
|
| Always display a particular worksheet upon opening Excel 2003 | 27 Sep 2007 13:38 GMT | 7 |
I have a Excel document that contains multiple worksheets. When I open the document, I want it to always open with a particular worksheet displayed (rather than the one displayed when I last saved the document).
|
| Problem with the 0 value | 27 Sep 2007 13:33 GMT | 2 |
I need a formula to compare the list of entries in a column and display the minimum of them at the end. For example from D1:D50, each cell has 0 value in each cell based on a formula (=A1+B1+C1), similarly for all the cells from D2 to D50.
|
| Data Changes itself after I have inputted. | 27 Sep 2007 13:25 GMT | 5 |
Can anyone help this luddite? I am constructing a table in Excel and have a column showing monetary amounts. However on one box, when I put the figure in then move on, the data changes to a date (13/02/1900). Any help much appreciated (need to get this
|
| excel formaula | 27 Sep 2007 13:25 GMT | 3 |
hi im trying to make a formaula on excel .2003 exmaple= colume A row 1 =fly then it will auto put in colume B row 1 2341 and so on . if you could help me take would be must greatful.
|
| FIND-COPY DIFFERENT WORDS WITH MACRO | 27 Sep 2007 13:20 GMT | 3 |
Hi, I am trying to create a macro that will find the word "MONDAY" in column A, then copy "MONDAY" (in every cell down to column A) and stop when it will find the word "TUESDAY" and so on.
|
| lock position of Word object in protected excel spreadsheet | 27 Sep 2007 13:09 GMT | 1 |
I have inserted a Word Document as an Object into an Excel spread sheet. I want the sheet to be protected but this renders the Word Object un-editable. If I set the Object as unlocked, I can protect the sheet and be able to edit the Object.
|
| Conditional Formating | 27 Sep 2007 13:01 GMT | 1 |
Is it possible to give background colour for a cell, if it shows some results(the cell contains a formula, with output True/False. I wish to do this without VB.(Conditional formating etc) Thanks in advance for your time.
|
| Calculating age differences | 27 Sep 2007 12:35 GMT | 6 |
I have two columns: chronilogical age and reading age. I need to calculate the difference between these ages. Age displayed as eg. 10:01 (10 years and 1 month) actual format is hh:mm. Please can someone tell me the correct formula?
|
| isoalting cells with data and copying to worksheet | 27 Sep 2007 12:34 GMT | 1 |
I have a document spread onto 3 worksheets. The first worksheet is 600 rows and 22 columns and is a report/checklist. In one of the columns are comments which I need to capture on the third worksheet because they are detailed as items to be corrected.
|