Merge multiple sheets with different columns into one

Hi,

I have two sheets with different number of columns and I need to combine them into one. For example, sheet 1 has Name, Age, Gender & Marital status and sheet 2 has Name, Gender, Marital status, Occupation & City. After I merge the data the final dataset in sheet 3 should be Name, Age, Gender, Marital status, Occupation & City. I'm currently using the macro below but it does not differentiate between the columns and copies everything. Can someone help?

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have fixed the code tags for you today. Please read all the forum rules and abide by them in the future.)