So the question is pretty straight forward. I have 2 sheets. One sheet is the one that contains underlying data. Let's say data range is 2 by 10 (columns by rows). If I were to repopulate the underlying data sheet and the data range changes (say 2 more rows) how can I get the sheet referencing this data to automatically increase by 2 rows as well? Do I need to write a macro for this? Any ideas would be greatly appreciated. Thanks!
Ken
Ken
