Hello everybody,

I'm not brilliant with Excel so please excuse poor explanation of what I want. I am a teacher and teach different classes over a week. I have downloaded a workbook for lesson planning. On the first sheet, every row is a day and I have entered my timetable, so it's like a table of five rows (Mon-Fri) and six columns (lessons 1-6), repeated to show enough weeks for the term.

In the workbook are separate pages for each class. So, for example, there is a page for my Year 11 class - this is a similar 'calendar sheet' and I can copy all of my Y11 cells from the first page into this grid and paste them into the right cells on the Lessons page. On the Y11 Lessons page, I can type in what I'm going to teach for each lesson and hyperlink to documents etc. This will show up on the first sheet.

I then have a timetable for the term on the first page, showing what I am teaching so I can see what I am doing on each day. Then I have a page for each class with all of their lessons mapped out. To do this, I have copied and pasted each cell from the timetable on to the relevant Lessons page but there must be an easy way to do this. I have asked the person who uploaded the workbook and she he has told me that he has done it the same way that I have.

Can somebody help me with this? Thanks in advance