I have a 40 year Capital Item Replacement Program.
This formula is in Row 4 , Columns B thru A
=if(ISNA(VLOOKUP(H2,Sheet7!$C$19:$C$D28,2,False)),0,VLOOKUP(H2,Sheet7!$C$19:$D$28,2,False))
Row 2, Column B thru AP =2002 to 2042. Therefore B2=2002 & H2 = 2008 etc.

my macro shows
Sub Insert()
'
' Insert Macro

The zillion books available on Excel are great on learning commands,
functions and syntaxes, etc.  But I can barely find information on a
systematic approach how to develop/design/model a spreadsheet.  I found one:
www.eusprig.org/smbp.pdf

Hi, I need a formula that will add all figures in a row except zero or blank
cells and then minus that figure from another cell figure - does anyone know
how to do that please? thanks

In 2003 you can add the + - * etc commands to the tool bar to allow you to
point and click as you create calculations in spreadsheets.
I cant see how to do that is  2007 - does anyone know if it is possibleA

I have 2 screens (monitors) for the same PC. I can not  manage to have a
different sheet (from different books/files) in each screen. All spreadsheets
behave as being stuck together (like being from the same excel file). Please
help!!!!

How do I  set a formula in the event the incorrect information based on the
following year month and date that is required.
is there a way that I stop a workbook that has 12 worksheet from calculating
the information every time the book is opened

Hi - I'm trying to use LINEST to create an automated, rolling multiple
regression.
In otherwords, rather than use the Analysis Toolpak over and over
again to run a regression with one more incremental set of data, I'd

I create a pull-down list in a cell by using Data ->Validation -> and input
the listing in the source box.  How can I set the pull-down list return to
the first data after each selection ?

I had a digital calendar with more than 1500 contacts saved in it. Now it's
broken and the company gave me the info saved, but instead of the data to be
organized separatly ( name, home address, phone (H), phone(W)..etc), it's all
mixed.

Hey, I'm wanting to do a sumif formula where the criteria is a certain
weekday.  For example:
=SUMIF(A10:A56,WEEKDAY(3),D10:D56)
Which, in theory would return the sum range wherever a tuesday occurs.  

I need to email only one tab from a workbook with multiple tabs...can you help?

how do I email a single worksheet in Office 2007. I have several worksheets
in a workbook but only want to send 1 of the sheets to someone and don't want
them to see the others. I could do it with older versions of excel but not
2007

Does anyone know how to make a format with a military-style date and time?  I
used
dd/hhmm/MMM/yy
so 1200 on January 1, 2008 would look like 011200JAN08, but when I go to

I want to display a league table showing first 5 names and their positions in
asscending order. There will be ties some weeks eg 1,1,3,4,5 and position 5
will sometimes be tied so I have left space for 9 possible "winners".
The names will go in H8:H16 and their positions in G8:G16 ...