| Thread | Last Post | Replies |
|
| Excel 2003 | 22 Jul 2006 16:33 GMT | 3 |
Got a silly problem. MS Excel 2003 Professional via MS partner pack (aka Action Pack) Start Excel as normal, no problem, clik on FILE on the menu bar and Excel stops responding. ALL other menu items work correctly. I've
|
| DELAY OPENING EXCEL FILES FROM SHORTCUT | 22 Jul 2006 14:51 GMT | 3 |
When I try to open excell file through a shortcut on my desktop, I have a +/- 15 seconds delay before the file actually opens. If I open excel previously and open a file it does so immediately I would appreciate help on this matter.
|
| Entering formula | 22 Jul 2006 14:03 GMT | 1 |
OK, first let me say that I am a complete idiot in the ways of Excel. That said, I need help entering a formula. Step by step would be nice or direction to a tutorial. ( I have used the help file to no avail). What I want is an Excel backup to what I use in the field on a TI-86 ...
|
| Excel data consolidation question | 22 Jul 2006 14:00 GMT | 20 |
I had a question -- I have a series of lists of users based on a userid text string and their name, some of which are duplicates. What i've done is import the lists into excel and then do a sort by userid. Additionally, I made a note of which database they're each in, using a
|
| reference different sheet in same workbook | 22 Jul 2006 13:29 GMT | 2 |
I've got a workbook with a number of worksheet tabs labeled "May 2006", "June 2006", "July 2006", etc in another tab called "Summary" I want to let the user enter a date and when he does the date will be used to figure out witch tab and from that tab
|
| More help needed re form & msgbox | 22 Jul 2006 13:05 GMT | 3 |
Thanks to those who helped earlier. I have two more questions (I hope that's all). Once again my code so far is: Private Sub cmdRemChild_Click() Dim myCell As Range
|
| annoying sort warning messages | 22 Jul 2006 13:03 GMT | 1 |
Since I am an extremely type-A, retentive person, I insist in entering codes, like area codes as text. New to Office 10, I am extremely annoyed to perform a Data|Sort, and get messages that all three columns contain numbers formatted as labels. Is there any way to turn that off!?
|
| Comparing info | 22 Jul 2006 13:01 GMT | 4 |
If I have a list of names (Last in one column, First in another) and fax numbers can excel compare and update or flag the numbers that changed or names who are not on the on the first list and also flag new names? Excel 2000 but could use 2003.
|
| finding a row with border in VBA | 22 Jul 2006 12:28 GMT | 1 |
i need to do 3things using excel VBA 1. finding the first row in a worksheet which have a border. 2. find the first cell which have contant. 3. is there a way to copy only partial cell contant?
|
| excel and outlook | 22 Jul 2006 11:59 GMT | 4 |
Is there a way of exporting to Outlook a list of email addresses that are listed in a column in an excel spreadsheet, with a view to batch emailing? Or do I have to cut and paste them all into the contacts section in Outlook? Or can I email to contacts from within excel?
|
| Special date format | 22 Jul 2006 08:38 GMT | 2 |
I'm trying to display the month in capital letters like this: JUL 21. I've tried to custom format using MMM dd but it displays as Jul 21. Is there a way?
|
| Macro Questions: | 22 Jul 2006 07:08 GMT | 3 |
Hopefully these questions wont sound too primitive: a) I've recorded a very simple macro that copies a row of date (C10 to O10) and pastes (paste special - values only) into a master work book. The entry point in the master work book is the current active cell; each new
|
| Excel Form and message box | 22 Jul 2006 06:03 GMT | 4 |
I'm running Excel 2000. I am just learning so please excuse my questions if they sound simple. To put this as simply as possible I have a spreadsheet of children's names. I've created a form that is activated by a control button. What I want to
|
| compute interest at 1.05% compounded daily on $77,000 for 5 years | 22 Jul 2006 05:17 GMT | 4 |
i have invested $77,000 at an interest rate of 1.05% compounded daily. i want to create a formula showing the yield at the end of 5 years (by day).
|
| remove shading when printing | 22 Jul 2006 04:50 GMT | 3 |
I have a form in excel that has the unlocked cells (the ones to be filled out) shaded so they stand out to the user. (FWIW, the form is an application for services) When this form prints, I would like it to print simply with no highlighted
|