How can I export data from one worksheet to another?
 

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?

How can I export data from one worksheet to another?
 

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.

"jtroberts" wrote:

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?

How can I export data from one worksheet to another?
 

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

--


Regards,


Peo Sjoblom

"Sean Timmons" wrote in message
...
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.

"jtroberts" wrote:

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?