My button contains month & year (i.e., apr-07,may-07....mar-08). If i
select a particular month in the button (eg: Aug-07). I should get
the total no.of months starting from apr-07 to aug-07 i.e., 5 months. Hence i
require a formula to get the total no of months as explained ...

I am using MS-Excel. I have copied some data in office clipboard. When I
choose the "Paste All" option it pastes all data down side, while I want to
paste the data right side / left side. How can I change it's pasting
direction? Please help me.

I have seen excel sheets where the header does not move when you scroll down
the page and it also reappears on each page when you print rather large
tables. How do you do that?

I would like to get a look up formula to look at multiple cells, for
example, I have London in A1 and transport in B1.  Then London in A2 and
Design in B2 This goes down to A800 and B800 with different locations and
roles.  

I have a spending chart.  For each transaction I list the predefined category
that the transaction falls under.  There are many categories and some of them
are repeated many times in one month.  What I would like to do is create a
box at the bottom of the sheet that will list ...

I have a problem where when I export some logs in an excel format the data
is getting exported in a jumble format. Even after using text to columns
option in the data tool, in one of the column a text is getting mixed with
the time format. I need the time format to be copied in ...

i have a date that changes every month in cell A1, ie, 31/8/07
in row 2, i have the months of the year, ie,
1/1/07   1/2/07   1/3/07 .... 1/8/07.... 1/12/07 (Note that i have to put
1st day of the month in order to do some calculations)

I can't seem to find how to track changes on the 2007 Excel. Can someone help?

Mr de Bruin, hate to impose for one last thing.  In the code you provided a
few posts back ("importing txt file help needed"), where (and what) do I use
to have the information come into the same workbook that the code is in?
Again, thank you for your help on this.

Please help!
I am currently working on a workbook that has various part nmbers
(2060207-WPI001) on work sheet 7-14-07 in E:E in which I match a 1 to
3 letter designations as in "WPI". In column AI:AI is the dates which

Is there a generic code that can be used to save the active wb to the users
personal default drive and document folder? (There is a fairly good chance
that the user won't have write access to the location that this original
template will be stored)

is there way to list values in an array or range, in a column?

I have calculated the number of days between 2 dates.  Now I need to convert
this answer (number of days) to the number of years, months & days.
xxx days = x years, xx months, xxx days

Is there a way to open a ShowDataForm in the Top Left hand corner, right over
the menu items (ie file, print etc). We're trying to use a scanner for input
and it can only see the very top left of a worksheet. Unfortunately every
time we open the Form it appears in a different ...

Is there any way to force count & sum to show up on the status bar at
the same time?
If not, can a toolbar be coded, and display those two variables as
calculated by VBA?