Is it possible to have an excel macro to automatically save many files in
another drive with the specific name of each file in its own folder using a
simple code? Currently, we use an excel macro to format text files to an
excel file with subtotals and they are saved to their own ...

I have the new Excel 2007, but in only shows 65,536 rows.  How can I get to
to show a million rows?

I would like to print the same column "AB" on 2 different pages.  It would be
the last column printed on the first page and the first column printed on the
second page.
Any suggestions?

Can anyone tell me why it is that if I click into a cell that has a formula
in it (for example =A4+A99), I can no longer use my scroll wheel on my mouse.
So, say I wanted to change the formula from A4+A99 to A4+ some cell that I
know is near to A99 but I don't quite know where, I ...

I am making this excel document and i have data on one sheet but want to
bring it over to sheet 2 to make it neater. when i try to enter in a formula
that will pull like from every 48th line it doesnt want to work. i tried =B2
then the next line =B50 and then tried pulling it ...

I have seen formulas that include two -'s.  I am not sure what this does.  Is
it just a way to add some spacing since two negatives equal a positive?
Example:
=SUMPRODUCT(--(A1:A100=1),--(B1:B100<>""))

I have a macro that opens a file on my network when I click on button.  I
want this macro to open a file that is in cell(14,1) no matter what the
file's name is changed to.  I've attached my current macro below.  If I
change the actually file name in VBA code, then it works fine. ...

In a macro, I am trying to transfer the values from a vertical named range to
a horizontal named range as described in the following example,
Test_Horizontal represents B2,B3,B4
Test_Vertical represents A1,A2,A3

I am making a basketball stats program.
I have a workbook where data is entered.  In this workbook there are 31
worksheets, one for data to be entered for each game.  The 31 worksheets have
all 23 players’ names down 2 columns on the left, and all the stat headings

I need help in determining the formula to lookup a value.  I am using two
worksheets I will call A & B.
On A, I enter a 3-letter airport identifier, ie AND (Anderson).  Using AND
as the reference, I want to fill in other information on sheet A from sheet

I am using formulas to bring cell data from one worksheet to another.  I also
want to bring forward the cell formats since some of the cells are color
coded.  
Cell formats on the source document may change as the data changes.  The

I have some labels on a userform that I set the forecolor property to
&H80000011& (Disabled Text). I want to be able to change the forecolor
between "Disabled Text" and "Button Text" (and vice versa) with code. I know
I can use RGB values, but I was hoping to use the same colors ...

I am linking 2 spreadsheets using information from 9 spreadsheets from 3
different locations. I have networked the 9 spreadsheets and networked them
to my desk top. I used the fully qualified addresses to link each cell, (not
X,Y or Z), however it still will not auto update my ...

I have a log with possible duplicate information.
There are three sections; the first two columns are aligned for all three
sections, like so:
A                       B                      C

Can you password protect a document from being opened?
Thanks,
Hamed Parhizkar