• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Consolidate data from multiple sheets in a new sheet.

S

soniaalalwani

New Member
Hi,


I would like to know if it is possible to consolidate data from various sheets into one sheet. Actually there are multiple sheets in my excel workbook. I want to create a macro in which i can select as to which sheets i would like to consolidate as i want only selected data and not everything in the consolidated sheet.

Eg. if i have say 4 sheets in my workbook, i want to give the user a choice to select as to which sheet he/she would like to add in the consolidated sheet.


I have created a code which takes all the sheets and consolidate it into one and am not able to figure out the above mentioned stuff. Please help.
 
Hi, soniaalalwani!


Tried using the search function for similar topics within this website? If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords "consolidate multiple sheets" and press Search button. You'd retrieve many links from this website, like the following one(s), maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.


http://chandoo.org/forums/topic/consolidate-data


Regards!
 
Hi,


I tried looking for the solution everywhere but was not able to. Actually i have created a code to consolidate the data in a specific manner. But this code will consolidate the data from all the sheets available in the workbook. I want to give user the choice to choose as to which sheets they want to add to the consolidated code. So i want that when the user click on the consolidated button a list should pop up which has the names of the all the sheets in the workbook and the user can handpick the sheets which they want to see in the consolidated sheet. Is it possible????
 
Hi, soniaalalwani!


Why not creating a work worksheet? Column A, names of all worksheets except that one (see code below), column B a value to decide if process that worksheet or not. And of course adapting your code -which you didn't post- to take care of those two columns.


-----

Dim I as integer, J as integer

Activesheet.ClearContents

I=0

For J=1 to ActiveWorkbook.Worksheets.Count

If ActiveWorkbook.Worksheets(J).Name <> ActiveSheet.Name Then

I=I+1

Activesheet.Cells(I,1).Value=ActiveWorkbook.Worksheets(J).Name

End If

Next J

-----


Regards!
 
You must log in or register to reply here.
Back
Top