Excel 2007 : Copy rows from one sheet to different sheets based on cell value

**Ireland316** · 04-26-2012, 05:26 AM

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

**JBeaucaire** · 04-26-2012, 06:33 AM

All the macros I've built to parse data from one sheet to many sheets based on the values in a column are done through autofilters, exactly as you've described. For example:

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.