Hello, hopefully someone can help me with this.  I have a main worksheet with
several columns (ie...Date, Vendor, Description, Water, Phone, Cable) I have
several rows with detailed information for these charges for multiple
properties, so it is alot, not just one each month.  I ...

I have a Excel report which as a report populated from a ADO VBA code
in a VBA subroutine which is driven from a button on the Excel
workbook which the user presses to refresh.
Also, I have some pivot reports on this workbook which is refreshed

I recive data in an excel spreadsheet that contains in one column a number
expressed as " 5.55" which is supposed to be a percentage, but when I try to
mailmerge the data, it mailmerges as "5.55061561650660". In other words it
carries out the decimal place more than 2 digits, ...

I received the following code from Bob Philips that looks for the max date
for a location (between those dates in column AH) and returns the closing
stock
{=INDEX(Closing_Stocks,MAX((StoreNo="London")*(SalesDate>=$AH$1)*(Inventory_No=$H$6)*(SalesDate<="$AH")*ROW(StoreNo))-1)/10}

When I change the Format|Cells|Number|Category of a selected column from
general to currency, any existing numeric data does not change to the
currency format ("$#,##0.00").  If I add new values, they take the currency
format.  How can I force all of the existing values to take the ...

Hi everyone, I need help with autofill. The situation is that I have an
excel spreadsheet that contain 2 worksheets: sheet1 and sheet2. The sheet1
basically contains just raw data; while sheet2 contains a number formula
that are used for calculation.

I have an Excel column with e-mails but they are hyperlinked.
So, I cannot edit them because it opens my e-mail server.
How can I remove the hyperlinks?
SantistaS

All
I have the following code which fires on opening of my workbook, problem is
I am getting an 'object defined' error. I think its because I have hidden
worksheets within the workbook, well at least it worked when I had none of

Does someone knows how to change the Titlebar.
I like to see an other icon and titletext.
Thanks a lo
--

Hello, everyone,
  My application has some interoperation with Excel,  but I cannot find one
detailed guide.
  can anyone help me ? thanks in advance.

Lets say for example I have a formula in row a1 and column a1 and some text
in a1 and d1.
What I would like to know how would I protected which I mean if I let others
use my spreadsheet I want to not let people change any info in that

I have my statement working OK, thanks to all.
=INDEX($E$1:$E$62933,SMALL(IF($B$1:$B$62933=B62938,ROW($E$1:$E$62933)),$F$2))
When the name is not found in the array,
I have a #NUM error value.

Excel 2000.  I have Cells B2 thru G2 available to be filled in with either a
1 or 0.  Some of the cells are blank.  I want to put a formula in cell H2
that will return the total cells that are filled in.  Right now B2 has a 1
and C2 has a 0.  I want H2 to return the number 2 or ...

Good evening...
I have the formula:  =SUMPRODUCT((B1:B5)*(A1:A5="baltimore")) to give the
sum of numbers that match Baltimore.
e.g.:

In the following macro I repeat the same section about 50 times and it
would be convient to put this into a loop.  However each time the
statement completes it uses a new paramter in the next section that
i've definined at the top of the VBA statement (seen below as sheet01,