Macro to move specific rows from one worksheet to another

I'm going to assume that you have all information that needs to be copied on some kind of master sheet, and the multiple worksheets that are setup in the same way that you mention are where you will be moving the details to.

If that's an accurate description, here's what I'd suggest:

Setup a variable to hold the position of the last row in the I column of your master sheet which contains data. Assuming your master sheet is named master, that line of code will look like this:

Please Login or Register  to view this content.

Then set up a for next loop to loop through each cell in the I column and move the data based on the value of the cell. I'm assuming that your data in the I column is "clean" meaning you won't need to check for cert, certification, certificate etc. The for next loop will look like this:

Please Login or Register  to view this content.

Note: I'm making guesses about the structure of your workbook sight unseen, and this code is untested. You will need to adjust it according to the names of your actual worksheets that you will be pasting on, and you will need to adjust the select case statements according to the actual values you expect to find in the I column of your "master" sheet.

Hi LaughingLaurie
Welcome to the Forum!
Were it me I'd consider filtering the data by degree criteria then copying the filtered rows to the target worksheets. If you need help with this please post a sample file...I'll be happy to look at it.

Hi LaughingLaurie

I know you didn't ask but I'd still recommend doing this with Filters

Please Login or Register  to view this content.