Hey everyone! This is my first time posting here
I've been scrolling through the forum for a solution to my problem but none seems to work!
I've just recently started doing macros and
I have a macro that would compare two excel sheets Col A(Sheet 1 and Sheet 2) and output the new data found in sheet 2 to the bottom of sheet 1 data:
Sheet 1:
<tbody>
</tbody> Sheet 2:
<tbody>
</tbody>
OUTPUT(Sheet 1):
<tbody>
</tbody>The problem is that now I wish to insert the new data to Sheet 1 by inserting new rows in between Sheet 1's data after comparison automatically so I get the overview of where the new data is:
<tbody>
</tbody>
Is there a macro that will be able to do this automatically?
Thank you so much for your help!
I've been really troubled over this.
I've been scrolling through the forum for a solution to my problem but none seems to work!
I've just recently started doing macros and
I have a macro that would compare two excel sheets Col A(Sheet 1 and Sheet 2) and output the new data found in sheet 2 to the bottom of sheet 1 data:
Sheet 1:
No. | Name |
A100 | Obj1 |
A300 | Obj3 |
A400 | Obj4 |
<tbody>
</tbody>
No. | Name |
A100 | Obj1 |
A200 | Obj2 |
A300 | Obj3 |
A400 | Obj4 |
A500 | Obj5 |
A600 | Obj6 |
<tbody>
</tbody>
OUTPUT(Sheet 1):
No. | Name |
A100 | Obj1 |
A300 | Obj3 |
A400 | Obj4 |
A200 | Obj2 |
A500 | Obj5 |
A600 | Obj6 |
<tbody>
</tbody>
No. | Name |
A100 | Obj1 |
A200 | Obj2 |
A300 | Obj3 |
A400 | Obj4 |
A500 | Obj5 |
A600 | Obj6 |
<tbody>
</tbody>
Is there a macro that will be able to do this automatically?
Thank you so much for your help!
I've been really troubled over this.