I'm trying to find out how to make a string variable's value the name of the
LAST sheet in an EXTERNAL workbook.  In lieu of actually setting a string
variable, I've been using msgbox just to see instantly upon running the sub
whether I've got it or not.

How can I suppress zero data rows in the new 2007 pivot tables?
Thanks,
Mike

I have 50 rows of numbers, with the last number being last number in the
sequence.  I want to reverse these numbers, so the most recent number is the
first number.  How do I do this?  Been up all night trying to figure this
out.  Thanks for you help, I just have to get some ...

Does anyone know how to insert blank rows into a pivot table (say,
between groupings, etc.)?  There has to be a way, since some of the
various table formats that come with Excel include blank rows.

I have 3 cells which I enter a start date this produces £229 in cell I23
=INT((DATE(I3,H3,G3)-DATE(E3,D3,C3))/7)*229
I then have 3 cells to enter a finish date this also produces £299 in cell
I24    =INT((DATE(I3,H3,G3)-DATE(E3,D3,C3))/7)*229

I'm sure this is a simple one:
I have two cells, A1 & B1
A1 = 3
B1 is empty

The COUNTIF function uses a number for setting the condition, for example
=COUNTIF(A1:A100,"<10"). How is it possible to replace the condition (in
this case "<10") with a cell address?
Thank you very much.

have a main spreadsheet to pull data from.that way an update to cells there
would flow changes to the other spreadsheets.Can that be done other than to  
manually
copy and paste?

Bonjour à tous,
Je voudrais "autoactiver" l'affichage des validations lorsque je clique dans
une cellule (proposée dans un classeur de JB)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

I am often faced with the task of moving data from excel workbooks
into numerous databases (Access, OLAP, SQL).  Here is my challenge:
I have a spreadsheet with the months listed in a row and the accounts
listed in a column, I need to create a record for each account and

I have  a spreadsheet with data in Column A.
Each particular collection of data is seperated by a single empty row
in Column A.
Each particular collection of data ranges from 1 row of data to 10 or

I have a question about quering an external database in excel. Everytime
when I refresh the data, I need to enter the user name, password & database
name, is there a way to store the password info in the file so that i dont
need to type it everytime.

This is way above my basic spreadsheet knowledge so please if anyone can
help.
I am trying to automate a small section of a booking form,  Example
In C7 26,  D7 5, E7 2008.     This represents 26th May 2008

Howdy Techie Folks,
I use Excel for a variety of functions, one of which is keeping track of
registration data at a motel I run. I'm required to submit occupancy data to
the county on a monthly and annual basis. One of the requirements is that I

I am building a spreadsheet query tool, the data is exported via flat
file and I convert it to .xls. There are mulitple files in the work
book and I need to be able to query the data from multiple
spreadsheets.  Would index / match be the best functions? Is there