Is it possible to get a column of cells to populate formulas based on a dynamic range? For instance I have a sheet of data that changes daily but my column of "if" formulas stays the same, which includes thousands of cells, which also is making the workbook huge it is also slowing it down. I have searched and found snipits of this question but I am not sure if any have given the answer. Anyway based on a column or columns of information, given a dynamic name so it is possible for it to grow by itself, can I make the column of formulas grow by them selves? Just incase here is an example.
If there is information in cells a1:a10 today then I want formulas in b1:b10, but if tomorrow Import my information and there is information in a1:a2500, then I want formulas in b1:b2500. Hope there is a answer to my question,
Thanks for all the help always,
Bob