I'm trying to make a simple macro. I didn't succeed so far. The problem lies on selecting the lines I want/need, then reallocate it to start of it (almost as splitting in half).
Example:
Result should be:
Of course, the number changes all the time, this is just an example, but normally I only need to keep the first 50 numbers in place, and then split from 51 to 100.
Any help is welcome.
Example:
Code: Select all
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
01 = 1000
02 = 2000
03 = 3000
04 = 4000
05 = 5000
Code: Select all
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
01 = 1000 01 = 1000
02 = 2000 02 = 2000
03 = 3000 03 = 3000
04 = 4000 04 = 4000
05 = 5000 05 = 5000
Any help is welcome.