Can someone explain to me how to use macros in excel? I know that on the
sheet that you want to designate the code you go to view code and paste it in
there but I dont know what to do after that in order for the macro to work.

Any help is greatly appreciated.

Thanks