Hi. I am needing assistance in creating a macro to find and replace contents of cells from one sheet to another. Sheet 1 contains the data I want to put into Sheet 2. Sheet 1, in short, contains a schedule for a person. I want to find in the log list of schedules in Sheet 2 the schedule for the person (Name is in Sheet 1, Cell A5) and replace their record in Sheet 2 with what is in Sheet 1. Can someone assist, please. I am just learning Macros and cannot figure it out.
Sheet 1, Row 5 A through P
<tbody>
</tbody>
Sheet 2, A through P
<tbody>
</tbody>
^ Lets just say that the third row above is what I want to replace with Sheet 1, Row 5 B through P, but it can be anywhere in the list.
Sheet 1, Row 5 A through P
Name | Title | 8:00 | 12:00 | 8:00 | 12:00 | 8:00 | 12:00 | 8:00 | 12:00 | 8:00 | 12:00 | OFF | OFF | OFF | OFF |
<tbody>
</tbody>
Sheet 2, A through P
Some Name | Title | 8:00 | 12:00 | 8:00 | 12:00 | 8:00 | 12:00 | 8:00 | 12:00 | 8:00 | 12:00 | OFF | OFF | OFF | OFF |
Some Other Name | Title | 9:00 | 13:00 | 9:00 | 13:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF |
Name | Title | 8:00 | 12:00 | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF | OFF |
<tbody>
</tbody>
^ Lets just say that the third row above is what I want to replace with Sheet 1, Row 5 B through P, but it can be anywhere in the list.