Hi,
I have a workbook with several sheets. They all contain similar data in a identical column sequence. There are however different amounts of rows in each column in each worksheet. I have been able to write a macro summarizing all the sheet names in one "summary" sheet, listing them vertically. In the summary sheet, I am interested in the SUM/Subtotal of one single column in the underlying work sheets (corresponding to the name of the tabs I was able to list). I have seen similar questions posted, however in my case the cell I am interested in is not in the same place in all the underlying sheets, as the sum cell changes depending on the number of rows.
Is there a way to merge/consolidate this one cell into the summary sheet? I have no clue where to even start this, so all help is highly appreciated!
I have a workbook with several sheets. They all contain similar data in a identical column sequence. There are however different amounts of rows in each column in each worksheet. I have been able to write a macro summarizing all the sheet names in one "summary" sheet, listing them vertically. In the summary sheet, I am interested in the SUM/Subtotal of one single column in the underlying work sheets (corresponding to the name of the tabs I was able to list). I have seen similar questions posted, however in my case the cell I am interested in is not in the same place in all the underlying sheets, as the sum cell changes depending on the number of rows.
Is there a way to merge/consolidate this one cell into the summary sheet? I have no clue where to even start this, so all help is highly appreciated!
