excel macro

i need a a basic macro who can generate a report by scrolling row with fixed colum and loop till the end of the row or a value that i can decide. budget will be very simple coz the operation is very simple, is just i dont know how to use excel with macro