Is there an Existing Command or a Way to Lessen Repetitive Spreadsheet

[KeiMartin]

Hello all.

Let me start out by saying that I am not a real Excel user. For me, Excel exists for an easy list maker.

Perhaps I did not query the database correctly but I didn't find an answer to my question. The situation is as follows: there is an existing Excel (2010 or 2013; it's a Mac) spreadsheet which is populated with columns and rows of information about newspaper publications. What the gentleman involved would like to do is be able to choose multiple entire rows (ctrl-click?) and when finished choosing have all that data appear in a new spreadsheet along with any calculations from the original document. This way he can avoid the copy/paste and figuring out the math that he has to do now. Is this what a macro is for?

Thank you for your time.