Hello
each week a spreadsheet of numbers is uploaded. the list length varies but the terms and conditions do not. (red at the top)
i have made the macro copy column a2 down to the end and paste into a seperate tab, then go to b2 and then paste it underneath and so on. thats working and fine
what i now need is too add 1+23 from A1 the correct number of times to the right of A2 downwards.
then take 1+23 in B1 and add it to the correct number of lines in B2 downwards
so , lets assume this has 100 rows
column A needs to be A2 down to A101 and next to this 1+23 100 times
if the list was 87 long, id need A2-88 and 1+23 next to it 87 times
then it goes to the next coulmn and repeats
thanks
1+23 | 1+23 | 1+23 | 1+23 | 1+23 |
8000 | 10000 | 12000 | 15000 | 20000 |
20.00 | 21.19 | 23.76 | 28.65 | 42.48 |
20.00 | 20.00 | 22.11 | 25.52 | 32.35 |
20.00 | 21.19 | 23.76 | 28.65 | 42.48 |
20.00 | 20.00 | 22.11 | 25.52 | 32.35 |
20.00 | 20.00 | 22.11 | 25.52 | 32.35 |
20.00 | 22.39 | 25.21 | 30.37 | 44.25 |
28.22 | 29.76 | 31.30 | 47.61 | 68.58 |
20.00 | 22.97 | 26.94 | 32.05 | 38.95 |
31.07 | 32.96 | 34.50 | 52.96 | 74.98 |
31.07 | 32.96 | 34.50 | 52.96 | 74.98 |
20.00 | 25.15 | 29.55 | 35.15 | 42.15 |
31.07 | 32.96 | 34.50 | 52.96 | 74.98 |
20.00 | 25.15 | 29.55 | 35.15 | 42.15 |