I have two spreadsheets. one of them has some information where one collumn will either be blank or have an "N". If it has an "N" I want certain collumns to copy over to a different spreadsheet. Can this be done in VB? How would I go about this chore? Thanks for any input.