Excel Worksheet transfer of Data
 

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

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

Excel Worksheet transfer of Data
 

If you mean .. data is continuously entered into a master ("parent") sheet,
and you wish to have lines neatly auto-copied to each individual ("child")
sheet based on the values within a key col, then try this recent response:

http://tinyurl.com/35nmlg
(includes a link to a sample)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MaggieB" wrote:
I need to transfer data from one worksheet to several others, any ideas how I
can do this? Gratefully accepted
--
MaggieB