| Thread | Last Post | Replies |
|
| sending an example to excel newsgroup | 04 Apr 2007 08:10 GMT | 1 |
I'm pasting a portion of an Excel spreadsheet to the newsgroup email I'm sending, but it converts to an attachment and does not get posted. I have pasted the Excel sample as a picture, bitmap and direct but each one converts to an attachment. Is there a way of including a ...
|
| having trouble locking hyperlinks in excel | 04 Apr 2007 02:28 GMT | 5 |
Hi all. I have a workbook with multiple worksheets. I have hyperlinks between the first worksheet and others in the book, just using the cell reference (eg E4). The problem I have is when I add a row, the links are messed up. I tried naming the cells I'm linking to, but then the ...
|
| countif | 04 Apr 2007 01:32 GMT | 5 |
Is it possible to use two criteria with this function? THX
|
| Find criteria and change offset information | 04 Apr 2007 01:01 GMT | 2 |
I am a beginner at writing my own VBA code. I have roster of names and associated information. What I would like my code to do is, find a certain value in column V and replace information in column AG & column AJ in the same row.
|
| how to shift with in sheets by keybord | 04 Apr 2007 00:13 GMT | 3 |
Hi Group, Can any one please tell me how to shift with in the sheets by keyboard Sam
|
| Charts generated by Data Analysis/Regression Add-in | 03 Apr 2007 23:29 GMT | 7 |
I've tried this on three different Excel 2007 installations in both 2003 and 2007 file formats: When I run a regression model on a set of data, the charts generated by the Add-in cannot be moved, resized, etc. without the chart
|
| Converting Lotus files to Excel | 03 Apr 2007 21:42 GMT | 3 |
This question may be a bit dated but I have some complicated Lotus files that need to be converted to Excel. These files were developed in ~2000 and use Lotus for Windows. They each are filled with worksheets that contain complex equations. The worksheets are inter-related. ...
|
| extract date between a given time frame | 03 Apr 2007 21:18 GMT | 1 |
I have the following problem: If a certain date falls within a certain time frame (e.g. 03/04/07 falls within 01/01/07 till 31/12/07), than cell should display "Yes"; If it doesn't, exel cell should display "No".
|
| Excel 2007 crashes, causes reboot | 03 Apr 2007 20:47 GMT | 4 |
Has anyone seen this behavior? Working in a simple spreadsheet in Excel 2007. OS is Vista Ultimate. (Dual core AMD/3 GB RAM) Three times today, and a few times previously Excel 2007 locks up and
|
| Copying Rows of Formulas | 03 Apr 2007 19:51 GMT | 4 |
How can I copy Row 1 down without offsetting the referenced cells? I copied it to Row 5 and it changed the reference to A5, B5, etc. A B C D
|
| HELP!!!!!!! | 03 Apr 2007 19:50 GMT | 12 |
I'm doing a sheet at work and I'm having some problems, I need your help! Whay I have is a sheet with some columns and rows. - 1: Can I put "filters" on SOME columns only? I can put filter with auto-filter to all columns, but it makes no sense... How to put on SOME only?
|
| Merging adjacent repeated columns with a macro | 03 Apr 2007 19:44 GMT | 2 |
I have a relatively large spreadsheet with numerous values repeated (within the same column) and I would like to merge adjacent, identical cells. I have attempted to tweak an existing macro that deletes repetitive,
|
| copying two charts | 03 Apr 2007 16:52 GMT | 2 |
I am trying to copy two charts along with its name and legend. When I past it in another worksheet I only get the legend and the chart name and NOT the chart. How can I copy both charts, name and legend at the same time? I have a list of charts that I need to combine in one page ...
|
| Is there a way to automatically add sequential dates in excell? | 03 Apr 2007 15:32 GMT | 1 |
Is there a way to automatically add sequential dates to a spreadsheet? For example, creating a spreadsheet for recording rental income, typing in each month manually or is there a function that will automatically fill the cells with the months of the year?
|
| Need help with Excel Validation Lists | 03 Apr 2007 15:24 GMT | 4 |
I am creating a validation list using VB macros using the following code snippet - -------------------------------------------------------------------------- ov.Validation.Delete
|