I created a thread yesterday https://www.mrexcel.com/forum/excel-questions/1102769-how-set-range-vba-active-cell.html
and this is the continue of my macro which I believe has to change what I had help with yesterday .
Sorry for not thinking the whole thing through before posting
Here is what I want.
If anyone can help. Please if you want also explain so that I learn sometimes I do not understand what the VBA does even if it works
thanks in advance
<tbody>
</tbody>
and this is the continue of my macro which I believe has to change what I had help with yesterday .
Sorry for not thinking the whole thing through before posting
Here is what I want.
If anyone can help. Please if you want also explain so that I learn sometimes I do not understand what the VBA does even if it works
thanks in advance
From this.(here under) It may be 1,2,3 or more column and different info | How many of each. This info is always in the most right column | ||
A1 | A2 | A3 | 4 |
B1 | B3 | 3 | |
Hello | 45 | 4 | |
asd | 1 | 10 | 2 |
This (here under) should be the result. The original info should be deleted | |||
A1 | A2 | A3 | 4 |
A1 | A2 | A3 | |
A1 | A2 | A3 | |
A1 | A2 | A3 | |
B1 | B3 | 3 | |
B1 | B3 | ||
B1 | B3 | ||
Hello | 45 | 4 | |
Hello | 45 | ||
Hello | 45 | ||
Hello | 45 | ||
asd | 1 | 10 | 2 |
asd | 1 | 10 |
<tbody>
</tbody>