I am trying to write a macro where I put the date in col A, go to col B and
put in the amount of gas, go to col C and put in price of gas, go to col D
put in mileage go to next col E an have it calculate miles per gallon then
ask if another entry is to be made.  Then have it go ...

I desperately need help here.  I have a spreadsheet that has sales price in
one column and the date in another column.  It will only add if the date is
the month only i.e., January vs January 1, 2005.  I need it to add by month
based on all days within the month because that ...

I have a spreadsheet that is used for a mail merge with names and
addresses.
Column A - Names
Column B - Number & Street

   I want to write a user-defined function to output an array. But I don't
know its codes. For example, if I want to define a function MyFunction(A,B)
where A, B are positive integers which generates an array such that the
entry in the x-th row, y-th column is x+y, what codes ...

Hi programmers,
I created a combo box in Excel 2000 and a linkedcell.  They worked very
well.  I updated to Excel 2003, and they don't work well any more.  The
problem is when I click down arrow to select a name in Combo box, it shows an

I have a range of cells (100+), which should all have a value of around
3600, so the average should also be around 3600 (minimum should not be lower
then 300, maximum shouldn't be higher than 10000). But sometimes some cells
contain values of -2000000 or +/-2 or +2000000. So when ...

I need to sort a list by group #.  The list consists of 8 colums of info
accross, and so i need to sort left- to right. Not sure how to go about doing
this correctly without losing info!
thanks,

Please can someone tell me how to stop my charts plotting zero values
at the end in cases where the chart runs for a longer period than my
data?
For example, my chart total date range is say Jan 05 to Dec 05, and I

I have all my income tax files in .qpw format but no longer have that program
to open them (computer change).  I now have Excel and was wondering how I
convert those .qpw files into Excel format?
Thanks

Given
A1: Name     B1: Dept        C1: Age
A2: Henry     B2: 501         C2: 28
A3: Stan        B3: 201         C3: 19

I have a bunch of spreadsheets that require passwords to open them, both to
read and to write. I put them on myself, but have forgotten what I did, and
I want to apply password protection to a new spreadsheet. The obvious thing
seems to be Tools/Protection/Protect Sheet or ...

Dear all, I hope someone can help me.  I have a worksheet of data
showing description down the left side, months across the top, and
amounts in the data fields, it look ssomething like the little table
below.  Note how I have several columns for each month, as the forecast

1. Enter an Excel worksheet and set via pull-down menu, Windows >
Freeze Panes at Row 1.
2. Set Print Area and hence Page Break Preview ; then, the worksheet
shows multiple pages.

I have developed a quoting tool which creates an output sheet detailing
all the info, What I would like to be able to do is take a copy of this
and paste the values (and Format to a new workbook). I'm currently
doing this manually and I unsure how to automate it!

In a row of 6 numbers I want to highlight the 3 largest numbers.  If the row
contains 7 or 8 numbers, I want to highlight the 4 largest of those numbers.
If the row contains 9 or 10 numbers, I want to highlight the 5 largest of
those numbers.  Any suggestions on how to make this ...