+ Reply to Thread
Results 1 to 6 of 6

Copy columns from one workbook to another when workbook is opened.

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    24

    Copy columns from one workbook to another when workbook is opened.

    Hi,

    I have done some searching but I'm not sure how this can be done, so please forgive me if it's in the wrong section.

    I have two workbooks,
    'Master Records'
    'Assessment Records'

    The workbooks are not saved in the same location and the Master file will not necessarily be open.

    When the Assessment book is opened I would like to copy certain columns from the Master sheet to Assessment. There is essentially an id field which links the records in the workbooks.

    The Assessment sheet has extra information which is linked to an id, so I would like this information to be maintained.

    Please see the attached files, and fire any questions back at me.

    Thanks
    Alex
    Assessment Records.xlsx
    Master Records.xlsx
    Last edited by gilko86; 05-11-2012 at 08:17 AM.

  2. #2
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Copy columns from one workbook to another when workbook is opened.

    When the Assessment book is opened I would like to copy certain columns from the Master sheet to Assessment.
    Which columns do you want copied?
    And what if that information has already been copied when the Assessment workbook was opened earlier?

  3. #3
    Registered User
    Join Date
    04-13-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Copy columns from one workbook to another when workbook is opened.

    Hi StevenM,

    I would like the following columns copied from Master to Assessment
    A --> B
    B --> C
    C --> D
    D --> A

    There is no need to re-import the information to Assessment if it was done earlier. I just need to check the Master file when Assessment is opened to see if a new person has been added.

    Thanks
    Alex

  4. #4
    Registered User
    Join Date
    04-13-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Copy columns from one workbook to another when workbook is opened.

    StevenM,

    It's actually related to the one you helped me with yesterday. The target for the copy and paste you did yesterday is the Assessment sheet (based on an ID lookup).

    Thanks
    Alex
    Last edited by gilko86; 05-11-2012 at 09:26 AM.

  5. #5
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: Copy columns from one workbook to another when workbook is opened.

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    04-13-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Copy columns from one workbook to another when workbook is opened.

    Perfect again! Thank you so much!

    Alex

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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