Results 1 to 17 of 17

Search workbook for matching detail and copy/paste the row/column content.

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003
    Posts
    8

    Search workbook for matching detail and copy/paste the row/column content.

    Hi all

    My first post, I am attempting to create a macro in Excel 2003 and unfortunately am struggling to get to grips with it. What I am looking to get running is a macro for the following:

    My workbook has:
    One sheet with name and staff numbers on only (Called Track)
    Several other sheets (called Course 09 , Course 11 etc) with several columns of info, including name and staff numbers.

    What I would like to be able to do is for a macro to look at the staff numbers on the sheet Track, then look through all the Course sheets and where it finds a match copy the contents of the matching row’s column C from Course into the matching row’s column C from Track.

    Alternatively and probably simpler if it finds a match just add Found or Not Found into the matching row’s column C from Track.

    Any help would be greatly appreciated.
    Last edited by GB.RTMC; 11-28-2012 at 04:04 AM.

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