Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have multiple source spreadsheets, each with a variable number of rows. An example might be one spreadsheet per bank account, with one row for each transaction, with a date and amount. One spreadsheet might have 30 rows, the other 50, and so on.

I want to create another spreadsheet which links to the various source spreadsheets and lists an aggregate of all transactions from all sources. So if 3 source sheets with 30, 50 and 20 rows respectively, the destination sheet would have 100 rows.

The number of rows (transactions) in the source sheets can grow or shrink over time. I'd like the destination sheet to show one contiguous list of transactions without gaps (spaces).

How can I do this?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Ron de Bruin did an awesome job on a solution for this situation. I've utilized it many times myself. Details here: http://msdn.microsoft.com/en-us/library/cc837974.aspx

share|improve this answer
    
Outstanding! Works perfectly. The solution is certainly more complex than I anticipated. –  Emilio Mar 19 '10 at 23:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.