Macro To Copy Data Down Column

[robertguy]

Hi,

What I need is a macro to look in column ‘A’ for the first code e.g. 1111 and then copy this code down in the blank cells in column ‘A’ until it finds the next code i.e. 2121, this should be repeated until there is no more data in column but the last code should be copied down to the last row where there is data in column ‘B’. I normally need to do this on a weekly basis where there could be hundreds of lines of data (with the data and numbers vary every week) so a macro would be really useful

Any assistance would be greatly appreciated


Many thanks in advance

Thanks again


N.B. Excel version 2007

Rob