| Thread | Last Post | Replies |
|
| how can I edit/change the font color in an excel formula? | 23 Sep 2006 01:08 GMT | 1 |
when I highlight to change the formula pops up but I can not chose a different color. How can I do this?
|
| Data Validation | 23 Sep 2006 00:53 GMT | 3 |
How can I implement a multi-column list for data validation in a worksheet, i.e., not in user form? I have a worksheet that user needs to pick a vendor from a valid list. I want to show both the vendor number and name on the list, but, I prefer not
|
| repeating data in other sheets | 23 Sep 2006 00:48 GMT | 4 |
I am trying to create a workbook that will take input from certain cells and populate that data in a particular cell on sheets 2 and 3. This will be to save people from retyping informaiton and provide me the important information I need.
|
| Macro to be used in any cell | 23 Sep 2006 00:16 GMT | 1 |
How do I make a macro available in any cell of a worksheet. I created it in a cell, but I want to be able to use it in any cell. Thanks. Range("L1058").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
|
| WEIRD QUESTION | 23 Sep 2006 00:07 GMT | 4 |
I have to calc every mth for the State of calif the following. you know how govn offices are????? if the amount is 56,995.87 I have to calc the following 5+6+9+9+5+8+7 = 49 + 7 =63
|
| Calendar function | 22 Sep 2006 23:52 GMT | 6 |
Dear Excel(lent) users ! Can somebody tell me how to insert a calendar in Excel ? And how can I add information behind certain dates? Is it also possible to transform it to html?
|
| random number generator | 22 Sep 2006 23:12 GMT | 2 |
I've been using the RNG and it works great... however, we need to take it one step further. I've looked all thru previous posts, but can't figure this out. I've got 10,000 names, addresses, etc all in a spreadsheet. I need to randomly select 100 and put those names, adresses, ...
|
| Links Don't follow with copy | 22 Sep 2006 22:37 GMT | 1 |
I have a group of worksheets that have cells linked among them. In the past when I would copy this group of sheets to a different directory all of the
|
| IF "A" is TRUE and "B" is TRUE? | 22 Sep 2006 22:17 GMT | 2 |
I want to write an IF statement that looks at values in 2 cells. Basically if D2=0 and D3="", then Enter "GOOD", "NO") I can't figure out how to get the IF statement to look at values in both cells.
|
| simultaneous subtotals | 22 Sep 2006 22:11 GMT | 1 |
I have a list of course rosters. I want to view subtotals of the following information for each course section: Total number of students Gender percentages
|
| how do i align numbers | 22 Sep 2006 22:07 GMT | 3 |
why i can align text and i cant alkign numbers even if i format numbers as text? can anyone help?
|
| Sorting | 22 Sep 2006 22:00 GMT | 2 |
I need to change an excel table to alphabetical order. I have 9 columns and 121 rows. I've tried with the sort button but nothing happens. Could somebody please give me some light in this? Thank you.
|
| VBE - Possible to have one of five modules in a VB project to be "default"? | 22 Sep 2006 21:58 GMT | 2 |
2003 Would like to have one of 5 modules in a VB Project to be the default Code window and in Explorer window. Is it possible? TIA EagleOne
|
| How can I use a long URL in a web query? | 22 Sep 2006 21:42 GMT | 1 |
When setting up a web query in Excel, the URL length is limited. However, the URL I want to use is quite long. I wonder if there is any way around this limitation.
|
| make it blank! | 22 Sep 2006 21:32 GMT | 3 |
cell A1 has no data and seems tobe blank. but in B1 when I enter =ISBLANK(A1) it gives me FALSE!! what's wrong with me and how can I make the cell actual blank???
|