Hi Harrison

Is there any particular reason for doing this with VBA, you should be able to do it relatively easily without any code.

Can you post a sample spreadsheet?