| Thread | Last Post | Replies |
|
| make image into autoshape | 27 Apr 2006 19:10 GMT | 2 |
I know how to draw an autoshape, and do the freehand, but how could I insert an image in as an autoshape? For example, I want to take an image which is an outline of a state (any state) and make it an autoshape, so that I can use the fill color tool and fill in the state a ...
|
| text wrap and change row height on different cells in an excel sheet | 27 Apr 2006 19:06 GMT | 2 |
I've been trying to look for a way to wrap the text and display it in the row by adjusting the row height. I have found a way of doing this for a selected cell, however i need my macro to be able to traverse through the sheet and perform the task. I am not familiar to vba
|
| Combining Cells | 27 Apr 2006 19:03 GMT | 2 |
I need the easiest way to do this: I have a column with values. Sometimes there are 2 rows, sometimes 20. For another program, I need all the values in that column in one long string separated by commas. So if my orginal data is:
|
| Conditional Sum of Quarters | 27 Apr 2006 18:23 GMT | 4 |
I have tried the conditional sum to calculate quartely results for the following: Measures Month Population Sample Population Missing/Invalid Population Numerator Missing/Invalid Numerator Denominator Observed Rate
|
| Vlookup/If? Formula problem? | 27 Apr 2006 17:59 GMT | 1 |
Having a bit of trouble working out a formula and wonder if anyone can help me... I'm trying to look up a value (quantity of parts on hand) based on two criteria (a part number and a revision)... the worksheet I'm looking up is
|
| ERRORS IN TVM FUNCTIONS IN EXCEL 2003? | 27 Apr 2006 17:32 GMT | 1 |
As I understand the descriptions of the PMT, ISPMT, and PPMT functions, the calculations returned for ISPMT and PPMTusing identical inputs should add to PMT for the same inputs. Can anyone explain why the first period's interest (ISPMT) plus the first period's principal (PPMT) ...
|
| Help with some formulas | 27 Apr 2006 17:31 GMT | 2 |
Well I have this problem, I need to determine the number of *days* (if a person's b-day hasn't passed during the current time) if the b-day passed I need to leave a blank or tell "b-day passed" I already have the age formula, The formula for the day of the week
|
| Excel Web Query | 27 Apr 2006 17:09 GMT | 3 |
I'm attempting to use Web Query to import a Web-based table into Excel in order to perform lookups on the imported data. The reference point is customer number - common to both my Excel sheets and the Web-based table.
|
| Clear History | 27 Apr 2006 16:45 GMT | 1 |
we have a spreadsheet that has columns for customer charges and totaling the charges from all columns and have a paid column for partial or full payment and then having a balance column we would like to clear old history Is there anyway to clear every 2 months automatically all ...
|
| Grouping / Ungrouping | 27 Apr 2006 16:39 GMT | 1 |
I have spent some time grouping rows on a large spreadsheet. Its quite big and complicated now and there are 5 levels of grouping. What I basically want to do is to remove the first layer of grouping so that the second layer becomes the first. Make sense?
|
| Trigonometry with excel | 27 Apr 2006 15:48 GMT | 6 |
If I wanted my answer in degrees for the following: opp side 8.3ft divided by adjacent side 5.8ft should give me 55.05 degrees. I have no problem with my little calculator but I'm having a difficult time trying to do this in excel.
|
| worksheet events and a little more help | 27 Apr 2006 15:45 GMT | 5 |
I'll start with the code i am using already: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Column = 6 And Target.Row > 3 And Target.Row < 256 And
|
| Creating and pasting using VB | 27 Apr 2006 15:20 GMT | 9 |
I need to create an email and paste some data already selected in excel into the body. I have just started to attempt this so if I need to add mapi or anything like that please let me know. Any help would be very helpful....
|
| Quick Question | 27 Apr 2006 14:57 GMT | 1 |
I have a workbook that is basically made up of 2 worksheets, a importing data sheet and a chart. Everything works great, timely refreshes and its rather simple. The problem I have is this: The chart is basically a seating chart and does not change at all(static). The 2nd worksheet
|
| Help with a formula to determine data presence in other worksheets in the same workbook | 27 Apr 2006 13:48 GMT | 2 |
I have a workbook with 20+ worksheets in it. Each worksheet contains a series of columns where generally the 'key' (not a real key but the term will suffice for this example) is in the first column and various attributes of that key exist in subsequent columns.
|