I'm using 2003. I know that you can use the fill series on dates to get
every weekday, every 4th of the month, etc. However, I would like to be able
to get a list of the dates for the last Friday of each month. Any ideas?
Thanks in advance

I have written a macro, which includes the following (and is working just
fine):
Range("B5").Select
ActiveSheet.HPageBreaks.Add Before:=ActiveCell

I need to add different numbers in column A to the value in C1.  (A1+C1,
A2+C1, A3+C1, etc).  Is there an easy way to get Excel to do this without
having to manually input the formula in each cell?
Thanks

When I saved my excel work sheet using 2007 microsoft office, all my Sheet
tabs at the bottom of the page has disappeared? How do I get them back?

I have an excel sheet with a bug it seems
all dates are displayed as serial numbers even if the formating says
date and so on... Even when i try to change the formatting nothing
happens.

The margins print margins need adjusting but I can only seem to change it
one sheet at a time. How can I make my change affect the whole document?

I'm sure there is a simple solution for this, but I'm new to tring to do very
much with Excel.  I have a list of tasks that are due on dates over a 6
months period. I would like to create a calendar for each month and for each
month  lists each tasks that occurs on on the ...

Pressing F9 / Shift+F9 doesn't update my calculated cells reliably, i.e.  
it just doesn't do it or gives wrongs answers.  The only way to get the  
right answers is to drag down the calculated cells again and then press F9  
/ Shift+F9.  Before going into more detail I just wanted ...

I am a newbie to the use of VB and Excel.  I am trying to sort the
range on Sheet 1..order by Company, then by Date most recent date.
Below is what I have but how can I make it acend?
Worksheets("Sheet1").Range("A3:g400").Sort _

every time i try to place a Date Picker object onto a excel form excel crashes.
Have ran diagnostics on office but it did not detect any problems

Is there a way to force the contents of a cell to conform to the format of an
I.P. address (e.g. nnn.nnn.nnn.nnn) ?
I looked in the tutorial format cell and found custom but no useful tutorial for
how to do it.

I have a formula like this ="TO COLLECT $"&SUM(G4:G999)-SUM(H4:H999)
     The results is this                    "TO COLLECT $60713.44"
     I want the dollar amount to look like this  $60,713.44
     Any Idea?

I would like to move data from excel file to another. I would like for the
existing data with column names to automatically fill into the second file
with the same column names but in different column locations. I know I can
cut and paste...but can I just match fields like when I ...

I have limited Excel experience so I need some help. A friend of mine wants me to create a form
using Excel. He is a horse trainer. To simplify things, I want to create a main form that would
include fields for Horse's name, Owner(s) names and contact info, Vet, Races, etc. I can ...

I use an Access dtabase with a reporting feature. I can export to Excell from
Access. I have created the template that I wish to use, but when I try to
export to excell I do not see the xlt. only the xls.
Do I also need to create a function in the Access database to download what ...