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.