Hi,
I know I came across this somewhere but I just couldn't recall where I have seen this been done with regard to summing across multiple worksheet.
Here is my problem. I have about 50 workbooks with similar layout and I have a summary workbook that basically sum up all value of these 50 workbooks. That mean in the Summary Workbook, cell A1 will be the summation of Workbook 1 to 50 and that is the same for Cell A2 and so on.
What I want to know if there is a easier way of summing up all these workbooks without having to open all of them and going to individual cell to achieve the desired result.
Many thanks for any suggestion
I know I came across this somewhere but I just couldn't recall where I have seen this been done with regard to summing across multiple worksheet.
Here is my problem. I have about 50 workbooks with similar layout and I have a summary workbook that basically sum up all value of these 50 workbooks. That mean in the Summary Workbook, cell A1 will be the summation of Workbook 1 to 50 and that is the same for Cell A2 and so on.
What I want to know if there is a easier way of summing up all these workbooks without having to open all of them and going to individual cell to achieve the desired result.
Many thanks for any suggestion