Hello I have 1000+ spreadsheets in a single excel file, and each sheet has a numerical table of 71R x 301C. I have to sum all these tables into one table (just like basic matrix summation) and wondering whether there's a macro for this. I have searched the net for a while, but couldn't find one.
Thanks in advance,
Al
what is the start and end range to sum?
Range is A1:KO71
This seems to work, it took about a second with 375 sheets, just having 1's and 2's in the cells.
I am not sure how big your value will end up being.
Change you destination sheet in the code.
Please Login or Register to view this content.
Thank you very much for the code bu maybe I did something wrong, but Excel gave me a single output value, I need to create the output as a matrix with same size (71x301).
Darn it, I was stuck in one direction.Originally Posted by Sickgeist
I will be back later.
Thanks for your effort once again, I pretty suck with macros
Ah at last I've found an easy way, =SUM('*'!A1) gives everything I need.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks