I am setting up an excel sheet to export journal entries to Syspro,  the date
column must be DDMMYY, if i go through format cells and custom DDMMYY, when I
enter the date it changes it to its numeric value.   Syspro needs excel to
show the date as 220807.   Please help.  Many ...

I have cells  Jan-07  Feb-07...etc (J3:U3).
I need copy paste 8 times to destination cells J13:U13 -J23:U23 -
J33:U33...etc
Is it possible to solve with macro.

I would like to pull through total amounts from a number of worksheets to sit
at the main front navigation page.  Within the worksheets, the total figure
sits in column C:3.  Each worksheet has a different name - for example:
Castlehead.  Hope you can help!

My computer is one of those that decides not  to be able to instantly open
Excel files by double clicking a shortcut, etc. (if Excel isn't already
open).
I did the recommended fix which I obtained via this newsgroup. ie. add [rem

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)