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?


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=479020