This is the step by step instruction of how to consolidate data in multiple sheets with the help of sample file.
You can find the step by step instruction in my blog.
caclubindia.com/blog/show_post.asp
Attached File : 6 consolidation(new).xls downloaded: 161 times
CAclubindia
