Hi I am hoping someone can help me,
I have a "Course Builder" sheet which people enter course codes onto, i have the macro to move the course info to a "Total Library" sheet and clear the data from the course builder sheet. What i would like to do now is have a macro/code that searches the "Total Library" sheet and copys a row from column H:R to another sheet based on the value in column C. For example column C value is "NRDC_" this row moves to a sheet named "NRDC", i have 11 different sheets to move info into. I would need to paste it into the next available row but not copy a course code if it already exists on the target sheet.
I can do this with a macro by filtering the data on Total Library for all 11 sheets and copy and paste that way, i was just wondering if anyone new of a smarter/quicker way of doing it?
Any help would be gratefully received.
Irleand316
Bookmarks