Hi all
Hi have sheet(data) and sheet(source) like belove
Sheet(data):
<tbody>
</tbody>
And Sheet(source):
<tbody>
</tbody>
Now I want macro to combine from sheet(source) to sheet(data):
if match value sheet(source).column(C) with sheet(data).column(A) => data will sort in by sheet(data).Column(A) and combine like belove
<tbody>
</tbody>
Please help me to do this by macro. I need row is dynamic, this mean use last row in sheet(data).columnA and sheet(source).column(C)
thanks./.
Hi have sheet(data) and sheet(source) like belove
Sheet(data):
A | B | C | |
1 | A123 | 999 | 888 |
2 | A124 | 456 | 789 |
3 | A125 | 123 | 456 |
4 | A126 | 741 | 852 |
5 | A127 | 987 | 987 |
<tbody>
</tbody>
And Sheet(source):
A | B | C | D | E | |
1 | ... | ... | A121 | 123 | 456 |
2 | ... | ... | A122 | 456 | 789 |
3 | ... | ... | A123 | 789 | 789 |
4 | ... | ... | A124 | 147 | 258 |
5 | ... | ... | A129 | 456 | 987 |
<tbody>
</tbody>
Now I want macro to combine from sheet(source) to sheet(data):
if match value sheet(source).column(C) with sheet(data).column(A) => data will sort in by sheet(data).Column(A) and combine like belove
A | B | C | D | E | F | |
1 | A121 | 0 | 0 | 123 | 456 | |
2 | A122 | 0 | 0 | 456 | 789 | |
3 | A123 | 999 | 888 | 789 | 789 | |
4 | A124 | 456 | 789 | 147 | 258 | |
5 | A125 | 123 | 456 | 0 | 0 | |
6 | A126 | 741 | 852 | 0 | 0 | |
7 | A127 | 987 | 987 | 0 | 0 | |
8 | A129 | 0 | 0 | 456 | 789 | |
9 |
<tbody>
</tbody>
Please help me to do this by macro. I need row is dynamic, this mean use last row in sheet(data).columnA and sheet(source).column(C)
thanks./.