I ma having a problem. I have a spreadsheet that has 6000 rows of formulas. Not all the rows have actual values in them. We fill the rows to variable lengths. Example, we may use only 400 rows one week, or 5000 another week, or all 6000 another week. But, every cell has to have a certain formula so that the data that gets input is gathered properly. The problem is that when I sort the data, it sorts ALL 6000 rows, even if there is no values (actual data) in them. Is there a macro that I can run to include all my formulas or a macro to sort everything? Thanks. I have attached a spreadsheet with some data. Or, is there a way to populate each cell with the formula as data gets entered?