Hi all,

Column A has a cell which contains date format and in column A ther
are about 50 cells which contains date format .

What i want is that a macro which upon finding a cell with date forma
, selects all the cells below it until a blank line below them comes.

like if in cell A5 there is date format and 6 cells below it has dat
and then a blank line, what i want is that it selects all those cell
which are below the date cell and pastes them in the column B

and dates may be in cell A2, A8, A20 etc which may vary.
sometimes below the date formt cell there is no data, just a blan
line.
any help is appreciate

--
Message posted from http://www.ExcelForum.com