Amend code to run faster

I have the following code kindly supplied to me by someone else and I'd like to know if anyone can suggest any ways to speed up the running of it. It currently takes about 4 minutes to run (there are about 5000 cells to loop through)

Basically it looks for a value in Col C - works out the number of rows to fill up by searching a range in Col D - then copies value in Col C up by that number of rows.

Please Login or Register  to view this content.

Any help would be appreciated

Regards

Seamus

Sure can, roy. Sample book attached.

Column C contains reason for activity (sickness, maternity leave etc). Column D contains the staff who worked those shifts.

Currently the reason for activity is only in the subtotal cell of col C and I need to "fill up" those reasons by the number of cells in Col D.

I'd be grateful if you's take a look at the book and advise me on the best way forward.

Regards

Seamus

Sorry roy. But that appears to change the values in Col D. Will keep looking at it though and try to figure out something.

Thanks

Seamus

Many many thanks roy,

With just a slight adjustment in the code it now woeks like a charm

Please Login or Register  to view this content.

Regards

Seamus

roy,

I Debug.Printed using your original code and it moved as follows, D2, E2, F2, D3, E3, F3 etc - I realise now that was because of the typo 6 instead of 4 - but I am now using your amended code.

Thanks

Seamus

Absolutely - this code just flies through in a matter of seconds while the old code looping through took between 4 and 5 minutes.

Good work

Seamus