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.

As I understand your question, the answer is no.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Big-Fish" wrote in message
...
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.

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).

"Big-Fish" wrote in message
...
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.