Morning all,
Is there an easy way to calculate the sum total of cells across every spreadsheet in a directory. EX. Cell A100 is a calculated total for the column. There is upward of 1,000 sheets in a particular directory. I'm looking for an easy way to have the total of every workbooks Cell A100 added together.
Creat a mater sheet, Use indirect to get all the values of A100 on the 1000 sheet, IF you have the file name of all the workbooks. Then sum all the values
I need your support to add reputations if my solution works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks