| Thread | Last Post | Replies |
|
| Need to merge two lists(worksheets) into one | 07 Apr 2007 03:53 GMT | 4 |
I have a list of names with addresses. I have a separate list of names with Phone numbers. These two lists are in separate workbooks. I can copy the work sheet of one into the the same workbook of the other, but I want to find a function,
|
| ROUNDING | 07 Apr 2007 03:04 GMT | 9 |
How do you round down to the nearest £0.25 please Thanks. Bill Ridgeway
|
| Web Query | 07 Apr 2007 02:43 GMT | 2 |
I'm not really sure if this an Excel issue but here goes. I have a file set up that gathers data from a web page. It updates web hits and other data from the page on a daily basis, the only problem I have is that I either have to leave the file open 24/7 or manually open it each ...
|
| Line in troolbar at top of page dissappears. | 07 Apr 2007 01:59 GMT | 4 |
All of a sudden the line in the toolbar at the very top of the page that I was working in just disappeared. How can I get it back? Don J ------------------------------------------------
|
| Splitting Cell Data From One Cell Into Two | 07 Apr 2007 01:21 GMT | 3 |
Hello, suppose you have an address or telephone list in which the first and last name are not in seperate cells, but in the same cell. I would like to somehow seperate the first and last name into two seperate cells. Is there any way to do this automatically?
|
| Date formatting | 07 Apr 2007 01:02 GMT | 3 |
I have this sheet filled with dates(hours & minutes worked per week/month/year) formatted for 24 hours/day using the standard date system. Now my employer wants me to make that same sheet to format those dates in workdays.
|
| Replacing data in Pivot Table causes Field name change | 07 Apr 2007 00:57 GMT | 10 |
Good morning, I have a pivot table report that uses about 1200 rows of data on a neighboring page. Today I produced new monthly data and pasted it on top of the old data. When I do this the report's left most column field names all
|
| inserting images into a single cell | 07 Apr 2007 00:25 GMT | 3 |
Does anyone know how to paste an image into a single cell please? If I click on a cell and paste into it - the image goes across multiple cells.
|
| Generating parts list from multiple sheets | 07 Apr 2007 00:14 GMT | 1 |
I am having trouble generating a parts list from multiple sheets in a workbook. I am calculating sell price for entire projects. I have many different furnaces that can be used and I would like to generate a list of the furnace and other equipment that I use into a final sheet ...
|
| stacked bars | 06 Apr 2007 18:21 GMT | 3 |
so I have a stacked bar chart by year (so the x-axis is running across 2000, 2001, etc). But now I want to stack another stack NEXT to the first (using the same time series 2000, 2001, etc) but without creating a totally different series.
|
| auto fill question | 06 Apr 2007 17:46 GMT | 3 |
i'm trying to use the auto-fill function to populate a column with a 'countif' function. although the formula is counting the number of occurrences of 'x' in a given column, i want to autofill vertically while the reference columns run horizontally. must the autofill
|
| Copy a file with only values no formulas | 06 Apr 2007 16:43 GMT | 2 |
Is there an easy way to copy a workbook so that it only has the values and not the formulas? Thank you.
|
| Lost functionality in Excel 2007 | 06 Apr 2007 16:28 GMT | 3 |
I often make scatter charts within Excel and I like to add trendlines to these charts, with the equations and associated R^2 values. With previous versions of Excel I could increase the precision of the equations using the "Increase Decimal" function in the toolbar. This
|
| Auto - backup in excel | 06 Apr 2007 16:21 GMT | 4 |
Dear Community, I wonder if there's an option in Excel that creates a backup every time of the file I edit. I need exactly the same that Word does with the "Always create backup copy" option. No, the autorecovery is not enough.
|
| Macro to copy text between two different delimeters | 06 Apr 2007 15:54 GMT | 1 |
I am trying to write a macro in Excel to select text between cells which contain words. Two challenges: 1.) I need to search for a cell that contains only one-single word
|