G
Guest
Workbook=37 worksheets
Sheet 1 is a summary sheet
I know how to add cells from all worksheets (2 -37) back to the summary
sheet 1(Sheet2!c3+Sheet3!c3)...all the way to Sheet 37
This is very manual. I need to perform this same function for 106 cells.
Is there a way to set up a range of the same cell from multiple worksheets??
I tried "sheet2!c3:sheet37!c3" to add all c3 cells from sheets 2-37 back to
sheet 1. Didn't work.
Sheet 1 is a summary sheet
I know how to add cells from all worksheets (2 -37) back to the summary
sheet 1(Sheet2!c3+Sheet3!c3)...all the way to Sheet 37
This is very manual. I need to perform this same function for 106 cells.
Is there a way to set up a range of the same cell from multiple worksheets??
I tried "sheet2!c3:sheet37!c3" to add all c3 cells from sheets 2-37 back to
sheet 1. Didn't work.