General

Format Date Filter Problem
I formatted a date from 4/20/2010 to April-10 I still have a hard time filtering my data. Eventhough it says April-10 it is still reading the day because the original date had the day in it. So it is filtering the days seperatly. If I have two dates: 4/19/2010 in row 1 and 4/20/2010 in row 2, I want to chan... 20 Apr 2010 14:30

Macro Code
You'd think this would be simple... How do I get a macro to move down 1 cell? I just want a macro to copy the contents of one cell to the cell below it. I have already done this: Sub CopyDown() ' ' CopyDown Macro ' ' Keyboard Shortcut: Ctrl+d ' Selection.Copy Range("A122").Select Active... 20 Apr 2010 09:18

league table sort
A B C D E F G H I J K L M N 1Team A Team D 2 0 TEAM P W D L F A Pt Dif 2Team B Team C 2 0 B 3 2 0 1 4 2 6 2 3Team A Team B 2 0 A 3 2 0 1 4 2 6 2 4Team C Team D 1 1 C 3 1 1 1 3 3 4 0 5Team C Team A 2 0 D 3 0 1 2 1 5 1 -4 6Team D Team B 0 2 Above is extract of my worksheet. Colu... 20 Apr 2010 08:16

Macro error
Hi I am trying to record a simple macro where if I press alt+d the location moves 7 "page down" key strokes - about 100 rows. However when I record the macro it resorts back to the line number that my macro originally ended up at 7 keystrokes from the top., even if I am 1500 lines down. How can I resolve this?... 20 Apr 2010 08:16

Excel slow!
Dear Reader, Hope everybody's fine. Great to be here. I work as an IT Consultant and some of my clients are having problems with excel, at a sudden excel is getting slow and slow without an apparent reason, calculations and navigation takes longer than usual on different and fast computers. However when the... 20 Apr 2010 07:15

Change ComboBox arrow colour????
Is there a way to change the colour of the botton/arrow that drops the combobox list. If there is a way, what I am after is to be able to change the colour of the button automatically if a item on the list is selected. Some would be red and others blue. ... 20 Apr 2010 11:22

#Name problem
While retriving data from a plugin. Instead of calculated values #Name appears in all cells. Thanks for the help ... 20 Apr 2010 06:13

Invoice created from Excel ocr Access and sent via Outlook
Hi, I am all new to this and do not know any programming. I have an excel sheet with Name, Address, e-mail address, amount to pay and an ID number. Is it possible to automate this and send an email with invoice to each and everyone of them? I would like for Outlook to atleast to put the different informa... 20 Apr 2010 08:16

data splitting
hello.. I have a column of data which i want to split into 2 other columns. For example, A B C ABC SCH, CDE SCH ABC SCH CDE SCH FGH SCH, FGH SCH - IJK SCH, LMN SCH IJK SCH ... 20 Apr 2010 06:13

excel 2007
how do I flip or rotate an image in excel 2007 ... 20 Apr 2010 05:11