Hello Mick,

Sunday, April 21, 2002, 4:23:08 PM, you wrote:

MF> Hello

MF> I'm working on a basic spreadsheet that will be a flight manifest for a
MF> helicopter. It consists of a column of names and has various weight
MF> calculations in the other columns. This is so we can calculate the all up
MF> weight of the aircraft. To simplify it each passenger is given an average
MF> weight of 90kg.

MF> Therefore, what I would like to achieve is that when a name is entered is
MF> (for example) in cell A12, then in cell D12 would appear 90. If nothing is
MF> entered in cell A12 then nothing is appears in cell D12.

MF> I hope I've explained the problem clearly and I look forward to your reply.

MF> Mick

You should to use the VBA codes!
For example, to fill two cell (A1 and D1) can be done by the following rows
  ...
    Range("A1").Select
    ActiveCell.FormulaR1C1 = "olex"
    Range("D1").Select
    ActiveCell.FormulaR1C1 = "90"
...
But in yours case you should to use the following additional construction
"If... then...else... endif" by yourself!
--
Best regards,
 Yakymakha

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                  http://freepctech.com/downloads.shtml