Hello, i have a long column pair of data, each entry in its own cell:
10/5/2008 8:30:00 AM
10/5/2008 8:46:00 AM
10/5/2008 9:14:00 AM
10/5/2008 10:18:00 AM
10/5/2008 10:42:00 AM
11/5/2008 8:30:00 AM
11/5/2008 8:46:00 AM
11/5/2008 9:14:00 AM
11/5/2008 10:18:00 AM
11/5/2008 10:42:00 AM
12/5/2008 8:30:00 AM
12/5/2008 8:46:00 AM
12/5/2008 9:14:00 AM
12/5/2008 10:18:00 AM
12/5/2008 10:42:00 AM
13/5/2008 8:30:00 AM
13/5/2008 8:46:00 AM
13/5/2008 9:14:00 AM
13/5/2008 10:18:00 AM
13/5/2008 10:42:00 AM
14/5/2008 8:30:00 AM
14/5/2008 8:46:00 AM
14/5/2008 9:14:00 AM
14/5/2008 10:18:00 AM
14/5/2008 10:42:00 AM
how can i program a macro to 'split' this column according to date? please refer to the attached picture as an example. i know this is probably a simple question but please bear with me i'm still new to excel programming.
thanks in advance!
Bookmarks