Thread
:
using data from one worksheet into another
View Single Post
#
2
R.VENKATARAMAN
Posts: n/a
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?
Reply With Quote