Passing data between spreadsheets

K

Kat

Is it possible to share data between spreadsheets? In
other words, when data is entered into one row, that
record is then transferred to another excel spreadsheet..
If so, how?
 
D

Doug Glancy

Kat,

Enter this formula in the cell in Sheet2 where you want the data from Sheet1
to appear:

=Sheet1!A1

No programming required. This is a very basic Excel function.

hth,

Doug
 

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

Need Help with Macro Security 1
Need Help with a VBA subroutine 0
Linking data in MS Word into Excel 5
Autonumber field in Excel that behaves the same as Access 0
Integrating information from Word to Excel (not mail merge) 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Designate font as italic of another 0
export data between spreadsheets 2

Top