using data from one worksheet into another
 

I currently have a excell file that has multiple worksheets. I would like to
add a worksheet that would allow for data entry. Once the data is entered
into this first page, i would like it to automatically fill in the same
information into the other worksheets. ie customers name would be entered
onto the first worksheet and then excell would put the customers name on all
the other sheets. how can i migrate this data from sheet to sheet?

try this

using shift or control key click all the worksheet tabs. all tabs will be
in whilte(i.e. all are active sheets)
now if you type something on A1 of first sheet the same will be entered in
all the sheets
once your action is over click any sheet, this operation of highlighting all
sheets will be removed.

try one or two experiments


mower man <mower wrote in message
...
I currently have a excell file that has multiple worksheets. I would like
to
add a worksheet that would allow for data entry. Once the data is entered
into this first page, i would like it to automatically fill in the same
information into the other worksheets. ie customers name would be entered
onto the first worksheet and then excell would put the customers name on
all
the other sheets. how can i migrate this data from sheet to sheet?

Thank You for your response. This works nicely. However, it brings up two
other questions. 1) Can i make this happen automatically? 2) what if i want
the data to be put into diferent cells?

"R.VENKATARAMAN" wrote:

try this

using shift or control key click all the worksheet tabs. all tabs will be
in whilte(i.e. all are active sheets)
now if you type something on A1 of first sheet the same will be entered in
all the sheets
once your action is over click any sheet, this operation of highlighting all
sheets will be removed.

try one or two experiments


mower man <mower wrote in message
...
I currently have a excell file that has multiple worksheets. I would like
to
add a worksheet that would allow for data entry. Once the data is entered
into this first page, i would like it to automatically fill in the same
information into the other worksheets. ie customers name would be entered
onto the first worksheet and then excell would put the customers name on
all
the other sheets. how can i migrate this data from sheet to sheet?