How can I export data from one worksheet to another?

J

jtroberts

I am looking to export data from one worksheet to another so that as it is
keyed into the "master" sheet it is populated in a secondary sheet. For
example, as I enter trainee information into a master record sheet, I would
like the data from columns A and B to populate a secondary sheet that I can
print off and use as a class roster.

Is this possible?
 
S

Sean Timmons

If you are looking to import all values, it's very easy.

If you have names starting at A2 and B2 of sheet 1, got to sheet2 and in
cell A2, type =Sheet1!A2, then copy and paste down and over to column B.

If it's more complex than that, please provide further details.
 
P

Peo Sjoblom

It's even easier to just copy the source and do edit>paste special and
select paste link in the
target worksheet

--


Regards,


Peo Sjoblom
 

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

Lookups - how to obtain data from a master spreadsheet into another 5
Cannot copy worksheet to another file 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I transfer data from one worksheet to another? (Excel 2003) 0
Link one worksheet in a workbook to another worksheet in same work 1
Find and TRansfer from another Tab in same Worksheet 3
MACRO for moving rows from one worksheet to another 3
How do I combine data (not consolidate) from separate tabs to one? 2

Top