I have over 60 worksheets in an excel workbook. I would like to add one column from each workbook onto a summary sheet. I do not want to add them all together I want to keep them separate.
A B
Sheet 1 1,000
Sheet 2 5,000
Sheet 3 7,000
And so on. Is there a Sumif function or something else that can help me with that?
Bookmarks