I need a macro written that will combine data found on two worksheets using an ID. In the example attached. Sheet1 and Sheet2 are the two tables to merge; the 'output' sheet is the expected result.
Please note that the macro needs to accommodate Sheet1 and Sheet2 with undefined number of columns. In other word, in the example, Sheet1 has 2 columns and Sheet2 has 3 columns but the macro should still work is Sheet1 has 10 columns and Sheet3 8 columns for example.
35 freelancers are bidding on average $40 for this job
HI I AM A BSCS MPhil AND I AM DOING THIS TYPE OF WORK AND THIS IS A WORK OF FEW MINUTES OR YOU CAN SAY THAT AN HOUR IT WILL TAKE I AM AVAILABLE FOR THE WORK PLEASE CONTACT IF YOU FEEL TRUST ON ME.