I have a spreadsheet that has weekly data on a particular property my firm works on. The data goes from last week of June 2012 and dates back all the way to 2010. I need to create a summary sheet that illustrates only the TOTAL weekly information (the Traffic, Unqualified Prospects, Qualified Prospects, and Rented numbers) vertically. Since there are a number of worksheets, should I be utilizing a Macro? How do I know which Macro to use?


ANY information would be greatly helpful!!!