Hi, any help would be great, I have 2 sheets, 1 being a timetable and another being a table.
i have drawn an image of what i mean.

The data on the timetable is to be put on the table in a list form (cannot use a macro as i have to sort the data and place on different tables)

Going back and forth to copy each cell is going to take too many clicks, is it possible to copy the data in a couple of clicks for each box?
So if i click on only "7:30" on the timetable it will also copy in the date, day and start time, end time.


i-want-the-click-to-do-this.jpg