merging two spreadhseets

[niket8989]

Hi,

I have two years of sales data for same and different product codes in different sheets for each year.

I want to merge both the sheets so that i have a consolidated view of both years data in one sheet.


Thank You

the sheets have columns that look like the one described as under:

Product code Month 1 m2 m3 m4 m5 m6 m7 m9 m10 m11 m12

[Pepe Le Mokko]

Try this addin ( code is also available). Be aware that this is a well known problem. Thousands of solutions all around

[niket8989]

Any other option that is in-built in MS Excel. basically tht does not require me to download/install any other software/tool.?