You could place your passenger manifest on a separate worksheet and create
your weight calculations on a different worksheet. It sounds as if you wish
to equate all passenger names to a value of 90.  You could add another
column for weight and set it equal to 90. This would allow some flexibility
in cases where you may wish to change the default weight.  If you only wish
to link these cells, it's pretty straightforward.  Copy the cell where the
weight is input, right click on the destination cell, select paste special
and then select link.  The result in the cell will be =xx, where x=column
and y=row.  If you wish to link between worksheets, the procedure is the
same but the destination cell will contain the worksheet name with a !
first.  You can use this method to set up a standard default worksheet that
supports any number of other worksheets.  The obvious benefit is that any
change on the default worksheet will ripple through to all the other
worksheets. I have attached an excel 2000 file as an example.  Not knowing
what your using, I saved it as an excel 5.0/win95 file so you should be able
to open it with almost anything.

Hope this helps.

Mike Gracewood, CET
Owner
1168 Smythe St.
Fredericton, NB, E3B 3H5
506-472-3377
506-472-1777(f)
[log in to unmask]
www.computer.nb.ca


  "The Things you Need",
The Service you Deserve

-----Original Message-----
From: PCSOFT - Personal Computer software discussion list
[mailto:[log in to unmask]]On Behalf Of Mick Fitzpatrick
Sent: Sunday, April 21, 2002 10:23 AM
To: [log in to unmask]
Subject: [PCSOFT] urgent Excel question please???

Hello

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

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

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

Mick

      "Hold No Punches.." Rode brings you great shareware/freeware
        programs with his honest opinions in this weekly column.
                       http://freepctech.com/rode

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