Hello,
I need a simple macro that will:
1. Sort Sheet 1 based on Number in column B and then in column A (note Sheets are named based on #s available in column A, then
2. Copy data from Column B to Sheets names corresponding to column A numbers
<tbody>
</tbody>
So, anything in column B with a #10 in column A, will be copied over to Sheet named "A". Same should repeat for any number #20 in A and so on until all Sheets have been pasted.
Thank you very much...
I need a simple macro that will:
1. Sort Sheet 1 based on Number in column B and then in column A (note Sheets are named based on #s available in column A, then
2. Copy data from Column B to Sheets names corresponding to column A numbers
A | B | |
1 | 10 | 11111 |
2 | 10 | 22222 |
3 | 10 | 33333 |
4 | 10 | 44444 |
5 | 20 | 11111 |
6 | 20 | 22222 |
7 | 30 | 11111 |
8 | 30 | 22222 |
<tbody>
</tbody>
So, anything in column B with a #10 in column A, will be copied over to Sheet named "A". Same should repeat for any number #20 in A and so on until all Sheets have been pasted.
Thank you very much...