Excel 2007 : How to Hide rows if data cells are empty?

I have a data entry script that fills from a second sheet. I have been trying to find a way to have the script line to hide if no data is available in the corresponding data line on the data sheet. I can perform this with a macro but I then have to have a macro for each data line. I would like it to be automatic. But my code writing skills are not up to this. Need help!