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.

Year	Stream	Semester	Subject	Class Type	Tutorial Code	Day	Start Time	End Time	Location	Room	Trainer Name
Certificate	Pastoral	2	Communication	Core	CC2P1	Monday	9:15 AM	11:15 AM	Waterloo	Main Aud	Trainer
Certificate	Pastoral	2	Personal Leadership	Core	CC2P1	Monday	11:15 AM	12:45 PM	Waterloo	Main Aud	Trainer
Certificate	Pastoral	2	Communication	Core	CC2P2	Monday	12:00 PM	1:00 PM	Waterloo	Main Aud	Trainer
Certificate	Pastoral	2	Personal Leadership	Core	CC2P2	Monday	1:00 PM	2:30 PM	Waterloo	Main Aud	Trainer

<tbody>
</tbody>

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.