Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

Excel Worksheet transfer of Data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MaggieB - 23 Jul 2007 16:00 GMT
I need to transfer data from one worksheet to several others, any ideas how I
can do this? Gratefully accepted
Signature

MaggieB

JLatham - 23 Jul 2007 16:20 GMT
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.

> I need to transfer data from one worksheet to several others, any ideas how I
> can do this? Gratefully accepted
Max - 23 Jul 2007 16:38 GMT
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)
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I need to transfer data from one worksheet to several others, any ideas how I
> can do this? Gratefully accepted
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.