Macro to search row and column for intersect and then input a data to where they meet

Hi,

Thanks for your help. Frankly, I am not sure that I have explained my problem very well at all. When I click the Allocate Cover button in the "cover" tab, I want the macro to do what it does now (copy and insert the table in new rows beneath) but also search the "timetable" tab for where to input the class. This would be done by using the data in column C and E, finding where they cross reference and insert the data from the same row in column D into that cell in "timetable".

I hope this makes life slightly clearer.

Thanks
Alasdair

Thanks for your help.

Unfortunately, I can't seem to get this code to work. It returns a runtime error 13 type missmatch. When I first tried it in the work book it was ok in that it copied and pasted the rows beneath. However when it did so, it did not paste the class into the appropriate cell in the timetable sheet.

Is there a chance you could have another look at it for me?

Thanks
Alasdair

Aaahh,

Right, yes I see. However, I still can get the class to input from the "Cover" sheet to the "timetable" sheet.
Any thoughts?

Thanks
Alasdair

If there is no data and the class column is reading #N/A, then I would want the macro to ignore it and not paste anything in the timetable sheet.

Is this possible?

Thanks
Alasdair

Sorry, it still wont seem to input the class into the timetable.

I have modified the sheet slightly. I have added an extra button called "Input to Timetable". For this button all I need a macro to do is insert the cells from the Cover tab in D21 and below into the Timetable sheet in the cell specified in H21 (cover tab)and below.

Is there a way to do this?

Thanks
AlasdairVBA COVER Forum Modified Version.xls