+ Reply to Thread
Results 1 to 2 of 2

Consolidate all the sheets into one master sheet

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    31

    Consolidate all the sheets into one master sheet

    I would like to consolidate all the sheets into one Summary sheet. However, here the difficult that I find is every time the starting range to copy the data varies. In one excel file all sheet range start from B12 but in another file all the sheets range start from C13.

    Is there any way that we can incorporate an input box which will ask for the starting cell to copy from. So once I give “B12” for example, it should copy from B12 until the last row of column B from all the sheets and paste in summary sheet.

    Please advice if this is possible.


    Thanks,
    Vignesh

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Consolidate all the sheets into one master sheet

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-21-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    31

    Re: Consolidate all the sheets into one master sheet

    Hi John,

    Thanks for your code... The only thing is, the input box is requesting a range for all the sheets. Suppose, if i have 30 sheets, i have to give the range for 30 times. However, in an excel file, all the sheets range will start with same row.

    If possible, can we alter a bit in such a way that input box will pop-up only once irrepective of how many sheets there are. So if I enter the starting range as "A20" it has to consolidate the entire row from A20 until the last row in column A from all the sheets.

    Also, the current code is not consolidating all the sheets. Please advice on this...

    Thanks for your consideration!!


    Thanks,
    Vignesh

+ Reply to Thread

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