LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default 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?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Excel WorkSheet Bette Excel Discussion (Misc queries) 0 July 11th 07 03:42 AM
Needed: worksheet export help mainemike Excel Discussion (Misc queries) 1 February 24th 06 02:59 AM
Import/Export XML in protected worksheet jgentillet Excel Discussion (Misc queries) 0 May 13th 05 05:42 PM
Export address list data in an Excel worksheet for importing into. ACR/HJG Excel Discussion (Misc queries) 1 April 15th 05 11:43 PM
breakdown a DB4 export into an excel worksheet Jim e boy Excel Worksheet Functions 2 March 10th 05 03:21 PM


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"