I need help in excel. I want to calculate total sums by multiplying 2 rows
then follow by addition. I have the rough idea how to do but the problem is
very complicated because I have 53 column of data. The 1 trying to do is like
this $B$1*B3+$C$1*C3+.....+$BZ$1*BZ3. Is there a ...

I have an Excel file, with over 100 worksheets. Each worksheet has tabular
data, with the same column heading, but not always the same number of lines
of data on each worksheet. I would like to be able to bring all data into one
single worksheet at the push of a button, by having ...

I have a shop with an e-procurement site that allows me to update a
price list by downloading a CSV file, making the changes, and then
uploading it back into there system.
The CSV file has the following headings:

Hi group,
This is my log <http://img3.freeimagehosting.net/uploads/
8218e756a1.png> (notice the double space before hours) and here are
the lists <http://img3.freeimagehosting.net/uploads/dad8c1362f.png>.

Can somebody post some good VBA macro for wrapping text in case of
merged cells (merged rows as well as merged colums or both merged rows
and columns).
Lot has been posted in this regard till now but i could'nt find any

This formula works:
=SUMPRODUCT(--($C$17:$C$200<>"")*--($K$17:$K$200="bjh"))
It returns an answer of 8, which is correct.
But I need to drag this down for fifty columns.  If I do that I'll

I have a column where I am putting in numbers with two decimal places.
On the toolbar I have aligned the column to fill in the numbers at 'Centre'.
The problem is:
If I put in a figure of say, 755.26 in a cell and in the cell underneath, I

I'm constructing a sheet to aid 5 departments handle backlogs.
The raw data is given to us from a database, in an excel format, once
every night.
I'd like to split the raw data from tab1 to tab2-6, depending on

How can you modify a autoshape (drawing shape) when used in excel to increase
the number of anchor points for adding connecting lines?
patrick,
ie box only has four, i want more

A two part question.
I'm reading in a csv file to Excel 2007.
It has a series of time values, for example:
"5:05:25.8127339 PM"

This problem is driving me nuts! The following Excel formula works fine in
several workbooks, but in one particular worksheet it generates the # VALUE
! error. Of course this is the one I really want it to work in. Any
suggestions of what I could be doing wrong?

I have been using Office 97 for several years (primarily Excel and Word)
and realize that it is no longer supported by MS, but since it still
worked and I couldn't afford to update, I just kept rolling along. Last
night however, I attempted to open one of my Excel files and got a ...

I am trying to create a dual entry system, a1=b1, and b1=a1; if I
enter a value in either a1 or b1 it is copied to the other.  Can I
program both to return a blank with the circular ref error.  This
returns 0 not blank:for a1 =if(iserror(b1),"",b1)     and for b1

How can I email one worksheet from a workbook in Vista?   In XP it
asks if you want to send the whole workbook or the sheet as the body
to an email.....  I want to sent a sheet as the body to an email.....
help please

I'm working with a school database I created from importing and merging
other peoples files and data.  It provides a list of all schools in a region
and the grades they offer.  The grades offered column is text and contains
string variables with different lengths, for example,