Create A Summary sheet from variable worksheets

Hi,

I need help with a macro for creating a summary sheet with variable work sheets in a workbook. The number of sheets will vary for each workbook. So, I would like to use this macro to create summary sheets for various workbooks. I completed the macro and everything is working fine except a minor issue. I also need to create a auto sum of rows in the summary sheet. I have attached the example worksheet to this thread. As the rows in the summary sheet would depend on the no. of work sheets, I need dynamic auto sum function and I am having hard time to sum the rows (the yellow shaded cells). Any help is greatly appreciated.

Thanks
Kish

I added some code to put the sum formula in your highlighted area.
Good Luck!!!

Thanks for the code Skywriter. I apologize for my late reply. The code is working fine but the sum formula is always displayed in the row "H". If I add another two or three sheets then the sum formula doesn't work. I wanted the sum function to be dynamic with the sheet numbers. Example: If there are 8 sheets then the sum formula should be pasted on "J" column and sum columns "C" to "I". Your help is greatly appreciated.

Thanks again for the reply. Actually, I slightly modified your code to do what I need. Thanks for your help on this. Have a great day!

Please Login or Register  to view this content.

I am having a hard time to find "SOLVED" for the thread. Anyway, thanks for your again.