Filling out forms and make one cell entry appear the same in anoth

[djang2003]

Hi. Im trying to computerize all our forms here in the clinic. I am trying
to make a workbook file for each patient, each containing at least 7 sheets
per work book. How do i make a cell entry appear the same way in another
cell, say in the same sheet and in another sheet? Something like an
automatic fill out with text in a cell?

Example: sheet 1: Cell a10: Name (text content)
Cell a11: Blank cell

sheet 2: Cell s15: Signatory (text content)
Cell t15: Blank cell

Is there a way to fill out cell a11 in sheet 1 and make the same text entry
appear in cell T15 in sheet 2 automatically? This would really help out the
efficiency in the clinic Help Thanks so much -- D

 

[Per Jessen]

Hi

In sheet2, T15 enter an equal sign then use the mouse to select sheet1, A11
and hit enter

The formula in T15 should now look like this:

=Sheet1!A11

Now when you fill in any text or number it will show in sheet2 T15

Hopes this helps

 

[Kassie]

Quite easy. Two things though. Would you want to copy the same name to more
than one cell? Would you like to keep it neat?

Taking answers to both questions as yes, then this is what you have to do.

In T15, you are going to enter a formula. This formula will obtain its
information from cell A10. However, if A10 has nothing in it, you do not
want T15 to show a 0.

The following formula will check A10, if it has nothing, it will show
nothing, but if it contains a name, it will show that name.

=IF(A10="","",A10), or in plain language, if A10 is empty, leave T15 empty,
else show the value of A10.

If you want to then copy this formula to all the other sheets in the
patient's workbook, I suggest you give A10 a range name, such as Patient, or
Surname.
Change your formula to =IF(Patient="","",Patient). You can now copy this
formula to all the other sheets, to have the patient name show in each of
these sheets, when you enter it in A10

--

HTH

Kassie

Replace xxx with hotmail