JamesT1973
New Member
- Joined
- Jul 23, 2010
- Messages
- 2
Hi all
Very new "VBAer"
I have Excel data as per below
<tbody>
</tbody>
I require this result
<tbody>
</tbody>
Can someone help with VBA code that will:
1) Copy down series in B1:B2
2) Copy down to last row in B, based on last value in Column A
Regards
James
Very new "VBAer"
I have Excel data as per below
A | B | C | |
1 | Location Code | Series Number | Country |
2 | 4000 | 1 | Australia |
3 | 4001 | 2 | Australia |
4 | 4002 | Australia | |
5 | 4010 | Australia |
<tbody>
</tbody>
I require this result
A | B | C | |
1 | Location Code | Series Number | Country |
2 | 4000 | 1 | Australia |
3 | 4001 | 2 | Australia |
4 | 4002 | 3 | Australia |
5 | 4010 | 4 | Australia |
<tbody>
</tbody>
Can someone help with VBA code that will:
1) Copy down series in B1:B2
2) Copy down to last row in B, based on last value in Column A
Regards
James
Last edited: