Entering the same data on more than one worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas that recognise data from two worksheets 1
Data from multiple worksheets 8
merging data/worksheets 1
Auto Populating & Name Recognition between Worksheets 1
linking data from one worksheet to another 1
Reference web query data in seperate worksheet 1
worksheet sorting and linking? 0
how to synchronize data value across two worksheets in one workbook? 2

Back
Top