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