Hi,
I need to combine 10-20 sheets data into a particular sheet in the same excel.
For eg: Sheet1 has columns Date and Name, Sheet2 has same columns Date and Name. I want to put this data into another sheet to get the combined/consolidated data.
Sheet 1:
Date Name
1/1/2016 Raj
1/1/2016 Venu
Sheet 2:
Date Name
2/1/2016 Renga
2/1/2016 Vivek
The new sheet should contain:
Date Name
1/1/2016 Raj
1/1/2016 Venu
2/1/2016 Renga
2/1/2016 Vivek
Please assist.
Bookmarks