i have 50 over worksheets and they are all the same format.
now , i want to consolidate all the datas( from the 50 sheets) into one worksheet.
now, i am using =sheet1!A1+sheet2!A1......sheet50!A1 to calculate the output
is there a better way of doing this? something like =sum(sheet1!:sheet50!)_all
the_cells_in_A1 without having to point to the exact cell of each worksheet?
Bookmarks