I have over 50 workbooks in a folder called ‘Report’. They all have
the same layout. Each workbook has 32 sheets (1-31 and the 32nd sheet
at the end is called ‘Total’) . I need to automatically open each
sheet in the folder, go to each ‘Total’ sheet and sum them in the 2nd
sheet of a file called “Alltotals’. ‘Alltotals’ has all the headings
and associated graphs. I would also then like that file saved as
“AlltotalsMonthYear” . The Month is in R1 and the year is in S1 on
the ‘Total’ sheet.
I have headings A5:S5 and A5:A61. The data I would like to sum is
B6:S6 to B60:S60. I am not sure whether using the consolidate and sum
function is best or if there is another way.
Thank you for any help.
Bob