Consolidate data from two sheets of same workbook

**indianhp** · 06-18-2013, 12:14 PM

Hi Team,

I have a worksheet which is having two data sheets getting data from SQL Query. Now Issue is that I need to combine both data into one sheet. I have tried to create macro which copy data from both worksheets one by one and copy it to one. But it does not work properly. I need to just combine both tables. I have attached an example sheet for the same.

Is there any function that can help to combine this data or macro. I have tried to modify SQL query but its not working. So I think only excel function or macro can do this.

**FDibbins** · 06-18-2013, 02:29 PM

Hi and welcome to the forum

What would your expected outcome look like?

**oeldere** · 06-18-2013, 02:51 PM

@indianhp

with the great help of other forummembers (Nilem and AB33) in the link below. I was able to made this code for your sheet.

http://www.excelforum.com/excel-prog...50#post3285950

Please Login or Register  to view this content.

**indianhp** · 06-19-2013, 01:18 AM

Hi oeldere,

Its working great as expected thanks for such a quick response. Actually I found its amazing that i also have a column in sheet which shows that from which i get the data. So, for any audit i can directly search that in perticular sheet from which that data belongs...

Thank you very much..