Everyday I create daily reports. They now want me to create a sheet that is constantly updated with a list of the reports I've done including a little information about it. I thought it would be great if at the end of my macro each of my reports all open up a "Work Completed File" go down to the next line and then have it fill in the information across that line based on what the report was on.

I just wanted to know how I would write VBA code that would find the next blank line and how I would write code to fill in 4 columns across based on cells of my report (everything is all excel). Then everytime I ran something, at the end of it it would do the same thing.

Can someone help me on that? I'm not sure how to make it find the next empty line and then allow me to fill in that line across 4 different cells in that row.
Thanks!

~J