new data with autofilter on
I am using auto filter in a file updated by multiple users. Users filter columnB to their particular name and then each week add their new data in next blank row. Various other columns have formulas entered which is already filled down further than data is entered. How do I get Autofilter to ignore 'blank' rows which only have the formulas? Say the next available row is 10 but the formulas are entered down to 100. With autofilter on it only shows row 100. Any ideas on how to get Excel to ignore the formula-filled columns?
I have Excel 2003 on XP.
Thanks.
|