View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Excel Worksheet transfer of Data

Can you be more specific? One way is to select the data to be placed in the
other sheet(s) and use a simple copy and paste.

Another way is by setting a link/reference in the other sheets back to the
original data. Example: You want the information in cell A1 on Sheet1 to
appear in other sheets. In those other sheets, enter the formula:
='Sheet1'!A1
and it will appear there. Excel will even help you do it properly:
Go to the sheet where you need a copy of the information and click in a
cell, type the = symbol to start a formula, then click on the sheet with the
information and then in the cell with the data you want, and finally press
the [Enter] key. Excel will create the proper formula for you.

You do not have to do that for each and every piece of information. Lets
say you need to 'echo' everything from A1 to F144 from Sheet1 in another
sheet. You can set up the
='Sheet1'!A1
formula in a single cell on the other sheet and then 'fill' the formula down
and to the right on that sheet and excel will automatically update the
addresses. See Excel Help on the topic of
Fill data in worksheet cells
and you'll probably want to examine the sub-topics of 'Use the fill handle
to fill data' and 'Fill data into adjacent cells'.

Hope this helps some.


"MaggieB" wrote:

I need to transfer data from one worksheet to several others, any ideas how I
can do this? Gratefully accepted
--
MaggieB