transfer information cells between spreadsheets

J

jimeeabaohe

How do I transfer information in one spreadsheet to another and have the
second spreadsheet automatically update?

Jim Parson
 
G

Gary''s Student

Copy the source cell.
Click on the destination cell and:

Edit > Paste Special... > and check link.
 
M

Max

Easiest way is to use simple links
to extract the source cell/range contents in the other sheet

Something like this
In Sheet2,
You could place this in any start cell,
say in B2: =IF(Sheet1!A1="","",Sheet1!A1)
then copy B2 across/fill down to C3
to dynamically link it to Sheet1's A1:B2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
 

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

Two Instances 3
How to get info transferred after "=A1" is used? 1
hide rows if nil result of formula in specific column 2
Formatting Cells between Spreadsheets 4
Excel realtime network update from source workbooks 4
Significant DELAY to open spreadsheets containing regular links? 6
tying 2 Excel spreadsheets together 2
Forumula too long 3

Top