I want to create a dynamic range name for a single column. The column will contain dates. The number of rows will change every month when the data is cleared and new data is pasted in. I want to refer to the entire column by a dynamic range name, but I want to end the range before the year 2011. I don't want to include any dates past 2010 in the range.
The column will be sorted in ascending order.
I have no idea how to do this. Any ideas?
Thanks
Jayb3369
The column will be sorted in ascending order.
I have no idea how to do this. Any ideas?
Thanks
Jayb3369