Need help with the following please... Looking for a way to have a pre-determined formula populate cells in Column K if cells in Column A have data. So, if A2 has data, I need a formula in K2. Formula for K3 if A3 has data (same formula) and so on. I would prefer not to use a typical formula such as "=IF(A2<>"",X,Y)" since this has the potential to cover 1000+ rows. Additionally, we will be deleting rows as they become old and/or obsolete. Any help would be greatly appreciated.