Screenshot1

Hi to the person who answered me. Thank you very much. I added your formula to my formula but it still gave me an error message. Please view screenshot 1 above.

Here is the link of a copy of my spreadsheet:

https://docs.google.com/spreadsheets/d/1bqOg1fRn8VFgdxJ-OZ_Yg-h8Pmxk_D0w/edit?usp=sharing&ouid=111851483886123696756&rtpof=true&sd=true

I removed a lot of other sheets (pages) so you will see lots of #REF! but that is ok as these columns have no importance in the matter. The columns that need to be looked at are Z on the first page (sheet) and AA on the 2n page (sheet).

So in the fist sheet called 24 KPI Weekly, I have to add the adresse of the deals corresponding to each row. This is our weekly keeping which I update periodically.

Instead of having to re-write these adresses into the quarter KPI page (the 2nd sheet), I wanted that the data be transferred (copied) there, and ignore empty cells.

Thank you so much for helping me with this matter Fannie