+ Reply to Thread
Results 1 to 7 of 7

How to copy sheet and paste it to other workbook, and automatically paste the data.

  1. #1
    Registered User
    Join Date
    03-09-2014
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    56

    How to copy sheet and paste it to other workbook, and automatically paste the data.

    For example i have workbook1,2&3, i want to copy the sheet(grade2&3) in workbook2&3 and paste to workbook1. But the data in workbook2&3 sheet(grade2&3) will automatically paste in workbook1 sheet(record grade 1 - grade 3) in column grade 2.. Thanks..

    see my sample workbook attachment and sample picture..
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-30-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: How to copy sheet and paste it to other workbook, and automatically paste the data.

    So If I understand you correctly, you want to make this process automated so you don't have to copy and paste?

  3. #3
    Registered User
    Join Date
    10-30-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: How to copy sheet and paste it to other workbook, and automatically paste the data.

    I have added links into the spreadsheets so you would enter data into the workbooks 2 & 3, then refresh the data when you open workbook one and it will automatically update.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-09-2014
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: How to copy sheet and paste it to other workbook, and automatically paste the data.

    thanks for the effort and reply sir.. your attachment is working but i want to copy only a sheet in workbook to other workbook. for example in workbook2 i have a multiple sheet named (grade 2, student name, exam result) but i want only the grade 2 sheet to be copied and paste it in workbook1.

  5. #5
    Registered User
    Join Date
    10-30-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: How to copy sheet and paste it to other workbook, and automatically paste the data.

    I guess I am confused when you say you want to copy a sheet... For the most part copying a sheet is with the mouse on the at the bottom tabs left mouse click, then choose move or copy, if you want to copy make sure you mark copy make a copy, and you can choose where to put the sheet... Or are you speaking copy ans in selecting cells, copy then paste?

    thanks,

  6. #6
    Registered User
    Join Date
    03-09-2014
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: How to copy sheet and paste it to other workbook, and automatically paste the data.

    yes i choose move or copy the sheet to workbook1, but i want it to automatically appear the data in sheet(RECORD GRADE 1 - GARDE 3).. Thanks for the reply..

  7. #7
    Registered User
    Join Date
    03-09-2014
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: How to copy sheet and paste it to other workbook, and automatically paste the data.

    anyway thanks again maam/sir IREED for the i will use your suggestion, i will group it in one folder.. thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy And Paste on Another Sheet ( next time paste data from empty row )
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-17-2014, 02:29 AM
  2. [SOLVED] Copy data in other sheet, paste and save it in a new workbook.
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2014, 09:30 AM
  3. [SOLVED] Copy/Paste Filtered Data To New Sheet In New Workbook.
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-13-2012, 09:10 PM
  4. Replies: 2
    Last Post: 02-22-2011, 02:07 AM
  5. [SOLVED] Copy and paste data from one sheet to another in a single workbook
    By SITCFanTN in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2006, 09:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1