How do I create a "macro" in excel that will find a value, copy that row, and paste it to another sheet?

I have a list of data, say 7,000 rows long. I would like to be able to search for a value, say all cells that say 'null.' I would like to then have excel copy the entire row and paste it to another sheet. How do I write this macro?