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