Using VBA to Copy/Paste data from one worksheet to another

[Bstatum]

Hello Excel Community,

I’m currently working on a university class scheduling project and am in need of some VBA coding assistance.

I would like to set up a system that can read data from a “Master” list and copy/paste specific information from the master sheet to another sheet based on certain criteria.
My “Master” list contains full class details (i.e Subject, Room, Time, Trainer, etc)

Once the list is read I would like to copy the subject name into an (already set up) “Day” sheet and paste the name into an intersecting cell that lines up with the current “room” and “time” information from the “Master”. (ex. The Communication (Subject) is in the Main Aud (Room) at 9:15am(Time).

I’m not quite sure if this is possible but I would appreciate any direction or if there is an easy way to achieve the same result.

Thanks for your input
-Bryon

Here are some better examples below.
[TABLE="width: 0"]
<tbody>[TR]
[TD]Year
[/TD]
[TD]Stream
[/TD]
[TD]Semester
[/TD]
[TD]Subject
[/TD]
[TD]Class Type
[/TD]
[TD]Tutorial Code
[/TD]
[TD]Day
[/TD]
[TD]Start Time
[/TD]
[TD]End Time
[/TD]
[TD]Location
[/TD]
[TD]Room
[/TD]
[TD]Trainer Name[/TD]
[/TR]
[TR]
[TD]Certificate
[/TD]
[TD]Pastoral
[/TD]
[TD]2
[/TD]
[TD]Communication
[/TD]
[TD]Core
[/TD]
[TD]CC2P1
[/TD]
[TD]Monday
[/TD]
[TD]9:15 AM
[/TD]
[TD]11:15 AM
[/TD]
[TD]Waterloo
[/TD]
[TD]Main Aud
[/TD]
[TD]Trainer[/TD]
[/TR]
[TR]
[TD]Certificate
[/TD]
[TD]Pastoral
[/TD]
[TD]2
[/TD]
[TD]Personal Leadership
[/TD]
[TD]Core
[/TD]
[TD]CC2P1
[/TD]
[TD]Monday
[/TD]
[TD]11:15 AM
[/TD]
[TD]12:45 PM
[/TD]
[TD]Waterloo
[/TD]
[TD]Main Aud
[/TD]
[TD]Trainer[/TD]
[/TR]
[TR]
[TD]Certificate
[/TD]
[TD]Pastoral
[/TD]
[TD]2
[/TD]
[TD]Communication
[/TD]
[TD]Core
[/TD]
[TD]CC2P2
[/TD]
[TD]Monday
[/TD]
[TD]12:00 PM
[/TD]
[TD]1:00 PM
[/TD]
[TD]Waterloo
[/TD]
[TD]Main Aud
[/TD]
[TD]Trainer[/TD]
[/TR]
[TR]
[TD]Certificate
[/TD]
[TD]Pastoral
[/TD]
[TD]2
[/TD]
[TD]Personal Leadership
[/TD]
[TD]Core
[/TD]
[TD]CC2P2
[/TD]
[TD]Monday
[/TD]
[TD]1:00 PM
[/TD]
[TD]2:30 PM
[/TD]
[TD]Waterloo
[/TD]
[TD]Main Aud
[/TD]
[TD]Trainer
[/TD]
[/TR]
</tbody>[/TABLE]

Time	Main Aud	2nd Aud	Music Room	Library 1	Library 2
8:00
8:15
8:30
8:45
9:00
9:15	Communication
9:30
9:45
10:00
10:15	Personal Leadership
10:30
10:45
11:00
11:15
11:30
11:45
12:00	Communication
12:15
12:30
12:45
13:00	Personal Leadership
13:15
13:30
13:45
14:00

<tbody>
</tbody>

 

[Macropod]

Bstatum: This is a duplicate of your thread: https://www.mrexcel.com/forum/excel...ba-copy-paste-data-one-worksheet-another.html

Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.