How can can I adjust the program below to:
Sheets("Sheet1").Select
cell = Columns("A:A").Select
'***PROGRAM START*******

This function is so wrong I am pulling my hair out.  Nevertheless I am trying
to sum column V if culumn U has a particular "item#" and the date in column A
is between two specified dates.  This is for tracking inventory on a
quarterly basis from a sheet that contains a years ...

I want to select an arbitary number of cells on my worksheet then show the
sum of those cells in real time in another cell, say display result in F5
cell, then if I select another set of cells then F5 update with sum of the
newly selected cells.

I would like to create a database of clients in Microsoft Office 2003 in
order to merge with an invoice without typing the customer information
everytime I need an invoice. I would like to be able to enter the client ID
#, which would import all the client mailing information I ...

I'm transferring a file from Mainframe into Excel where I can manipulate the
data.  Everything was working just great until I realized to my shock and
dismay, that negative numbers in Mainframe are (ex.) 16- instead of -16,
which means they are formatted as text when they import ...

Excel 97.
Column/Row  B2 = text value
Column/Row  O2 = Date value
I need a formula to evaluate as follows:

26:47:00 -> 1/1/1900 2:47:00 AM

12:49 -> 12:49:00 PM

Hello > Sometimes, when I type a simple formula into a cell ( e.g.
=IF(A1=A2,"dupe","ok") ), the formula does _not_ evaluate when I press
[Enter] or if I move on to another cell.  The formula just sits in the
cell, as typed.  I do not undertand what the circumstances are that

I’m having a scaling issue…
=QUARTILE(Sheet1!$C$2:$C$45,A3) works well!
A3 resides on sheet2.
Also on sheet2, resides =COUNTA(Constructs!P2:P10000) in cell Q1

I apply color on columns bt can see colors until I go to print preview. Why
is not shown colors in cells in workbooks?

I know I've done this before but can't remember how.
How do you find the number of the week in a given month?

i have to add cells evenly spaced, eg a1 + a11+a21+...+a991
how can I avoid writting all references?

Quickbooks 2005~06 compiles ypur Customer:jobs list with the jobs related to
the customer below & indented to the right, eg;
John Smith
   Kleenmaid washing machine

Thanks for any help on this.
I have a spreadsheet that looks like
MATURITY        AUSTRIA    BELGIUM    FINLAND    FRANCE
4/24/2006        2.651    0    2.651    2.507

I tried most of the posts for vlookup, but wasn't successful.  Here's my
problem:
I have 2 values in the same row in table2 (cells A5 and B5), for which I'd
like to look up the matching row in table 1, which has a different structure.