Results 1 to 17 of 17

Consolidating Columns from Multiple Sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-24-2010
    Location
    BC, Canada
    MS-Off Ver
    Excel 2010
    Posts
    174

    Consolidating Columns from Multiple Sheets

    After the help I've gotten in other threads I'm almost done my project!!! I will end up with multiple sheets that automatically pull data from a master budget. Each sheet will vary in length and will allow for automatic detection of new accounts on the master budget. The reason for having separate sheets for each section is to that I can quickly verify the totals for each section in case the automated list doesn't balance. Now what I want to do is make a sheet that consolidates all of the other sheets. I included a simple attachment to show you what I am trying to do. I made some attempts at variations of INDEX and a few other things but I could not get it to work.

    Any suggestions?

    Thank you.
    Attached Files Attached Files
    Last edited by The Phil; 03-16-2010 at 06:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1