Transferring cell info to another spreadsheet

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

Guest

Can a spreadsheet be setup to select a cell and have that info transferred to
another spreadsheet without using copy and paste.
 
If your just wanting to display the result of a cells contents into
another sheet try this:

Let's say you have data in cell A1 on sheet1 and you want it in cell B1
on sheet2...

You would put the following into cell B2 on sheet2:

=Sheet1!A1

Any data in cell A1 on sheet 1 will now be displayed in cell B2 on
sheet2.


Hope this helps you...
 
You must log in or register to reply here.

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

Tranfering data from one spreadsheet to another Automatically 2
transferring data to new multiple spreadsheets 1
Excel Linking (I think) 17
Lookups - how to obtain data from a master spreadsheet into another 5
How to transfer the data from userform to spreadsheet for specific dates 0
Cell shows the last typed text, no matter where it is typed 0
Locating Info In New Excel Spreadsheet When Compared To Old One 4
Differences Between Two Spreadsheets ? 1

Back
Top