Copying a formula to dynamic range

[2vao]

hi all,

I checked all the threads that could be altered a bit to get what I want, but I believe because of my very limited knowledge of VBA, I couldn't reach anywhere. Here is what I have:

- Formula in cell D3 that counts the number of records based on the value of cell A11.
- An array formula in cell B11 that I want to copy down to a dynamic range starting from Cell B12: the number of rows will depend on the value of D3 each time A11 changes.

What I want to happen each time A11 changes is:
-A code that clears range B12:B
-Copy B11 to Range B12:B(12+whatever the value of D3 is)

Kindly help, will appreciate it very much.
Thanks

 

[2vao]

Thanks Joe for your reply,

here is my screenshot, I hope this help. Thanks


[FONT=&quot]
[/FONT]

 

[JoeMo]

Thanks Joe for your reply,

here is my screenshot, I hope this help. Thanks

Your screenshot didn't make it. Can you just describe it in words? Also, can you answer this question from post#10: "Do you not see View Code on the context menu when you right-click the sheet tab?"