Hi I shall try to explain clearly what I need to be able to do, here goes:
I have an Excel spread sheet 1 with postcodes in column a and a number in column b. I need to create a macro/formula so that it will see the number (i.e 4) and copy and paste the postcode that number of times into sheet 2 column a underneath each other. I need to do this for the next row down etc until it comes to a blank.
Sheet 1
A,B
DE43PP,3
DE43PQ,8
Sheet 2
A,B
DE43PP,
DE43PP,
DE43PP,
Thanks