Hi All,
I'm trying to create a marco that will:
- compare rows of data on different worksheets.
- When a match is found , copy a specific cell on the matching data row in sheet 1
- Then paste the copied data next to the matched data on sheet 2.
The data I'm comparing in the example is:
Name
Year
Month
Week - week number of that month
The comparison is made between the 'Master' worksheet and the individually named worksheet in this case 'A' 'B' 'C'
All 4 sets of data must match on one row and when they do I need to copy over whatever is in the 'Data' column on the 'Master' sheet to the matched row to the relevant sheet.
I've included an extra 'Sample' sheet for quick refrence of what i'm after
any help/pointers of where to look or how to go about this problem would be much apprenticed.
it seems a simliar problem to http://www.excelforum.com/showthread.php?t=646523
Bookmarks