Creating Almost Duplicate Macros Shortcut

Can you include the macro of Prices#Days#?

I have one quick question.

If your code above will be change to Prices4Days4 what will be its new code?

try this one:

Please Login or Register  to view this content.

Okay. Let me know if there will be any bug.

Seems to work ok. I have now tried to adapt it to the full code which I will be using and not just the snippets above. Can you let me know if the below is correct overall?

Please Login or Register  to view this content.

The problem at the moment is that the word "Done" appears all the way done the page when it should only appear if FindMethod4Days# is called.

I think your code will work well.
I've made some adjustments on the part with red font. I only merged it on your code above that.

Please Login or Register  to view this content.

Please include your code on FindMethod4Days.

Give this a try. I'm not sure if this is what you want to happen.

Please Login or Register  to view this content.

Originally Posted by ScabbyDog

The problem at the moment is that the word "Done" appears all the way down the page when it should only appear if FindMethod4Days# is called. Any ideas how to fix that?

What do you mean of this? In your FindMethod4Days there is also a loop that I think that will do the same as the previous one. Can you attach a sample workbook?

Originally Posted by ScabbyDog

It seems to work. But it goes on a huge loop I think?

Yes I think. There's a lot of for loop on the code. You could upload a workbook and an output of it so we can know what would be much better for that. Unless you need that urgent, you could use the code above.

Replace your old FindMethod4Days3 with this one.

Please Login or Register  to view this content.

That's weird. Here is the code;

Please Login or Register  to view this content.

Please see Post#21.

Condition already applied.

Originally Posted by ScabbyDog

Doesn't work. When I change the J column to 4 then it doesnt copy over the figures.

Do you want it to happen at worksheet_change?
Because I have run your code and it seems nothing wrong in it.
My understanding is, even there is no word "Done" in column I and column J has a value 4, the macro will run.
Is my understanding right or not?

Is the text with red font doesn't fit the condition?

Please Login or Register  to view this content.

again. kinda weird. From the highlighted text the macro will not run anymore even there is a value of 4 in J4.

Please Login or Register  to view this content.

Originally Posted by ScabbyDog

The code in Red is Correct. If .Range("J" & x) = 4 Then Call Prices4Days3(x). That is what I want. BUT what I am saying is that when for example J20 changes to value 4 and I run the macro nothing will happen because I3 value will be Done.

If I3 is Done then nothing else will run even if J4 value is 4.

Do you want that if you have already filled up the I3 with "Done" and J3 with 4 it will stop the macro?

Not sure if this is it. Getting hungry.

Please Login or Register  to view this content.

Hopefully this would do.

Please Login or Register  to view this content.

let me edit this:

Please Login or Register  to view this content.

Okay. It now works perfectly. There is only one issue. If J3 = 4 then everything works perfectly. But if J3 changes to 3 (which will happen tomorrow) then no other figures will get copied over even if Jx = 4. But if I change J3 manually to the figure 4 then everything works again.

A potential fix would be to have maybe another macro that will recognise if a cell has the value 4 and if it detects the value 4 then it will change the cell to a number which isn't affected my any formulas/macros??

I found a fix by deleting the Exit Sub code after Else.