i have in column A:A a various list of dates in the following format
12/08/2006 Saturday
I want to create a list of the available months in column A:A to use in
a drop down menu.
This is a general format so ive not been ale to go for the max numeric
value although i can do a datevalue function(leftx,5)) to get the value
and then find the max date but this causes the workbook to slow as i
would have to run this against 9 imported worksheets. Also the rows
used vary on different imported time ranges.
As the dates are in acending order and the last date is always a given
number of rows from the end i wondered if there is a way to find out
how many rows had been used. There are also blank rows in between so
ive not been able to go down this road.
--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread:
http://www.excelforum.com/showthread...hreadid=566515