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.
Bookmarks