I have created several sheets that I use as different forms, one is a billing
sheet, and one is a data summary sheet. I need this information to remain in
a patient's file and I am constantly changing the headers to include the
patient's name and medical record number. Is there a way that I can type
this information once somewhere, then have it placed on every sheet within a
workbook?

On your other worksheets, enter the formula =Sheet1!A1 (changing the sheet
name and cell reference to match your needs). In this example, any data
entered into cell A1 on Sheet1 will automatically populate to the other
worksheets that reference that cell.
--
Elisabeth


"DouglasGrantPhD" wrote:

I have created several sheets that I use as different forms, one is a billing
sheet, and one is a data summary sheet. I need this information to remain in
a patient's file and I am constantly changing the headers to include the
patient's name and medical record number. Is there a way that I can type
this information once somewhere, then have it placed on every sheet within a
workbook?

Thanks for you response. This will be helpful with some types of
information. Can I have this information placed into the header on other
worksheets?
"Elisabeth" wrote:

On your other worksheets, enter the formula =Sheet1!A1 (changing the sheet
name and cell reference to match your needs). In this example, any data
entered into cell A1 on Sheet1 will automatically populate to the other
worksheets that reference that cell.
--
Elisabeth


"DouglasGrantPhD" wrote:

I have created several sheets that I use as different forms, one is a billing
sheet, and one is a data summary sheet. I need this information to remain in
a patient's file and I am constantly changing the headers to include the
patient's name and medical record number. Is there a way that I can type
this information once somewhere, then have it placed on every sheet within a
workbook?

Hi Douglas,

You may like to use a Macro for this. If this entails a series of tasks
which you do repeatedly everytime you have a new patient, then you can record
all these tasks as a macro.

To record a new macro, go to Tools-Macro-Record new macro

If you are new to macro recording, you might want to use the basic help by
pressing F1 to see how to do it.

Regards,
Sameer Nagi

"DouglasGrantPhD" wrote:

I have created several sheets that I use as different forms, one is a billing
sheet, and one is a data summary sheet. I need this information to remain in
a patient's file and I am constantly changing the headers to include the
patient's name and medical record number. Is there a way that I can type
this information once somewhere, then have it placed on every sheet within a
workbook?

Sameer,
Thanks, this may be helpful. If I combine the information that Elizabet
told me about and the macro, that may just work. Thanks

"Sameer Nagi" wrote:

Hi Douglas,

You may like to use a Macro for this. If this entails a series of tasks
which you do repeatedly everytime you have a new patient, then you can record
all these tasks as a macro.

To record a new macro, go to Tools-Macro-Record new macro

If you are new to macro recording, you might want to use the basic help by
pressing F1 to see how to do it.

Regards,
Sameer Nagi

"DouglasGrantPhD" wrote:

I have created several sheets that I use as different forms, one is a billing
sheet, and one is a data summary sheet. I need this information to remain in
a patient's file and I am constantly changing the headers to include the
patient's name and medical record number. Is there a way that I can type
this information once somewhere, then have it placed on every sheet within a
workbook?