| Thread | Last Post | Replies |
|
| Printing Single Worksheet Multiple Times with Different Data | 16 Oct 2007 17:53 GMT | 6 |
What I am trying to do is use a single worksheet pulling data from a different worksheet to print multiple copies of the original worksheet. Similar to a mail Merge, but basically to copy a daily number and date from the second sheet and use it as a variable on the first ...
|
| Match Up/Merge Records | 16 Oct 2007 17:39 GMT | 1 |
Using Excel 2003 I have two spreadsheets. One contains 168 records and the other contains 376 records. The spreadsheet with the 168 records includes the following columns:
|
| Searching for specific Geophysics visual basic code | 16 Oct 2007 17:05 GMT | 1 |
Time ago I have the opportunity to see an Excel sheet that implemented an algorithm for automatic processing and interpretation of Schlumberger sounding curves in 1 dimension (EVS). a difficult geophysics calculus, because it use superior maths, but it works very very well. I ...
|
| Duplication Q. | 16 Oct 2007 16:13 GMT | 2 |
Is there a way to identify duplicate entries in a column without deleting either one? Respectfully, V Morningstar
|
| Excel 2007 cannot print multiple copies | 16 Oct 2007 16:03 GMT | 3 |
We have a problem printing multiply copies of our excel documents, only 1 copy is printed. This started after upgrading from Office 2000 to Office 2007. Printing is generated on HP 3500 / 3700 Color Printers.
|
| Count Unique Items with Multiple Criteria | 16 Oct 2007 15:46 GMT | 12 |
I am trying to get a list of how many lots a particular car model is on. For example, say we have a spreadsheet that looks like: Model License Lot Ford xjd-394 1
|
| enter figures in timesheets and it updates a job costing sheet | 16 Oct 2007 14:19 GMT | 4 |
I have set up a job costing sheet and a timesheet, the staff fill in their timesheets and I entre them on to my system in excel and then I got a job costing sheet which gives me details on how much a job is costing us, I would like, when I enter figures into the timesheet it ...
|
| printing in excel 2007 | 16 Oct 2007 13:28 GMT | 1 |
How do I print worksheets without having to set the print area each time?
|
| Name Files with Spaces or with Underscores? | 16 Oct 2007 10:03 GMT | 3 |
What's the convention now? In Windows XP, do we still need to compose file names with _, so that "latest model.xls" becomes latest_model.xls? Is this even necessary? If not, why are people still nameing files with the underscore.?
|
| Excel 2007 Pivot table's Report filter fields value sorting | 16 Oct 2007 09:10 GMT | 1 |
I have an excel sheet with huge data in a pivot table and some report filters for the pivot table. but the list for each report filter is not sorted. how do i get a sorted list for each report filter. Any help would be appreciated. thnx in advance
|
| Spell Check | 16 Oct 2007 07:39 GMT | 1 |
Am typing ADN but it automatically changing to AND...which i dont want.
|
| Matching records (Excel 2007) | 16 Oct 2007 07:33 GMT | 5 |
I have two text files: FILE-1 has 2,500 rows, each cell contains a nine-digit number. Examples: 391300004
|
| Windows Installer Starts Everytime Excel 2007 runs! | 16 Oct 2007 00:27 GMT | 1 |
I have Office 2007, everytime I run Excel 2007 the Windows Installer/Configuration box pops up and essentially installs Excel(EVERYTIME), as you can see this is very annoying, it takes up to 2 mins or longer many times, I have gone to many sites and forums, I have changed
|
| sumproduct using a date range | 15 Oct 2007 23:01 GMT | 3 |
this is the formula that I've used before but not needing dates so I'm having trouble. =SUMPRODUCT(--('PO Numbers'!$K$4:$K$240=17407),--('PO Numbers'!$A$4:$A$240=1/0/7),'PO Numbers'!$J$4:$J$240)
|
| Calculation Times in Excel XP vs. Excel 2003 and 2007 | 15 Oct 2007 22:54 GMT | 19 |
This is a strange one. I have an Excel workbook that was created in Excel XP. It has 4 total sheets -- 2 with data that's calculated, and 2 that are just for data lookups. Most of the functions employed are standard... included in Excel's library. It also uses 2 custom
|