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 :D Help :( Thanks so much -- D