Hi everyone,

I've been trying to solve this for a while but its got me tearing my
hair out!!!

I want to create a macro that when run will summarise columns or rows
from different worksheets and return them to a new sheet that is
inserted at the front of the workbook.

In an ideal world the macro would bring up a box that would ask for the
rows or columns to be summarised. I would then enter the required
rows/columns ie, column a, click on ok and every column a in all the
worksheets would be returned to a new sheet at the front of the book.
ie if there are 3 sheets, column a of sheet 1 would be returned to
column a of new sheet, column a of sheet 2 would be returned to column
b of new sheet... etc to allow comparison.

I appreciate this is in all likelihood a large query but if anyone can
help in any way i'd be very grateful!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements