Entering the same data on more than one worksheet

B

Big-Fish

I need to put the same information in more than worksheet. the information
will be in diferent locations on each work sheet. However some information
will appear from different worksheets into the same collum of the final
worksheet, ie date, time.
Is it possible to do this and if so how with out entering the data repeatedly.
 
R

Richard O. Neville

Data that will be in exactly the same cells in two or more worksheets can be
entered in all of them by selecting the sheets as a group (use the Ctrl key
if they are not contiguous). But if the cell locations are different, your
choices are (1) to copy and paste the data, or (2) to create a link between
the source worksheet and the destination worksheet(s).
 
Top