I'm working through a large data set that is a bit of a mess. The column I'm trying to deal with has a combination of client numbers and dates:
12684632
12/2/14
1/23/15
368543286
11/3/14
385498651
11/2/14
etc...
I'm trying to figure out a way to find the next cell that contains a date (basically the next cell that contains a /), select it, and select all cells below that also contain a /, stopping when the next cell does not contain a /
e.g. in the figure above starting at the top, the first two dates (12/2/14, 1/23/15) would be selected, then some other vba runs and does its thing (I've got this part working), then selects the next date (11/3/14), etc.
Any help would be really appreciated. Thanks!
Bookmarks