Macro doesn't run till the end

[graiggoriz]

Hello,

I have problem with the below macro. When I run it I have the pop up to ask me to fill in the E6 cell but the rest of the script does not run... can you please help me?

Also how can I add more cell to be filled in?? should I do like:

[patel45]

can you attach a sample file with data and desired result ?

[JasperD]

First things first - to add in more cells, use this :

Please Login or Register  to view this content.

Now for your code, problem could be that you switch to a different worksheet but don't specify it iin the code.
Try this :

Please Login or Register  to view this content.

Please click the * below if this helps

[AB33]

Please Login or Register  to view this content.

I suspect the loop should be column E, not A