Hi Every one,
I required a macro or Formula to Auto insert the Row after matching of two Spreadsheets
Table 1/Spread Sheet 1/Work book 1
<tbody>
</tbody>
Table 2/Spread Sheet 2/Work book 2
<tbody>
</tbody>
Output
<tbody>
</tbody>
Thanks in Advance for every one
Thanks & Regards,
Raviteja
I required a macro or Formula to Auto insert the Row after matching of two Spreadsheets
Table 1/Spread Sheet 1/Work book 1
Name | ID | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug |
Ravi | 42 | 10 | 96 | 14 | |||||
ravi | 14 | 10 | 11 | ||||||
fbgsdf | 52 | 246 | 455 | 5525 | 536 |
<tbody>
</tbody>
Table 2/Spread Sheet 2/Work book 2
Name | ID | Feb | Mar | Jan | Jul | Aug | Apr |
Ravi | 14 | 50 | |||||
teja | 85 | 516 | 365 | 585 | 4 | ||
dfsgbd | 96 | 76 | 78 | 547 |
<tbody>
</tbody>
Output
Name | ID | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug |
Ravi | 42 | 10 | 96 | 14 | |||||
ravi | 14 | 10 | 50 | 11 | |||||
fbgsdf | 52 | 246 | 455 | 5525 | 536 | ||||
teja | 85 | 365 | 516 | 585 | 4 | ||||
dfsgbd | 96 | 76 | 78 | 547 |
<tbody>
</tbody>
Thanks in Advance for every one
Thanks & Regards,
Raviteja