software

I am creating quite a large workbook with in excess of 50 worksheets. I am
currently having trouble as I cannot add any furhter sheets or change

Excel 2000

I use excell to build a batebase up, and I wish in certain columns to have
the first character to be in uppercase, how do I do that?

Objective: populate a cell with the contents of another cell by reference
using the '=lt;cell_location' paradigm

Hi I would really appreciate some help with this problem. I have a table of
data that I am using a lookup on, so that I can preset formulae I am also

How could this formula be simplified?
=IF($D$2=1,K13,IF($D$2gt;=2,SUM(K13:L13),IF($D$2gt;=3, SUM(K13:M13),IF($D$2gt;=4,SUM(K13:N13),IF($D$2gt;=5,SU M(K13:O13),IF($D$2gt;=6,SUM(K13:P13),0))))))

Hi
I have a macro (double click) assigned to a keyboard shortcut.

I have several objects which over several months will change color several
times.

Hello! I have a spreadsheet with January 01, 2006 thru December 31, 2006 in
ascending order in column A, each date in a different cell (A1, A2, A3,

I have a worksheet (Data):