Hello,
I have a sheet that is a schedule. It looks like this...
Column A Column B
2/20/2009
12:00 PM
1:00 PM Dave
2:00 PM Jonathan
3:00 PM Steve
2/21/2009
1:00 PM James
2:00 PM Sally
3:00 PM Tyler
4:00 PM
5:00 PM John
6:00 PM Betty
I am needing to create a Macro that does this:
Cell B4 is selected by user and then runs the macro. The macro then looks UP (B3, B2, B1 etc) cell by cell until it finds the first cell that has a valid date in it and if that date is same as the date that the macro is being run pastes "This Text" into the comments section (Not replacing everything in the comments but simply adding to it.)
Any help is very much appreciated!
~Tyler
I have a sheet that is a schedule. It looks like this...
Column A Column B
2/20/2009
12:00 PM
1:00 PM Dave
2:00 PM Jonathan
3:00 PM Steve
2/21/2009
1:00 PM James
2:00 PM Sally
3:00 PM Tyler
4:00 PM
5:00 PM John
6:00 PM Betty
I am needing to create a Macro that does this:
Cell B4 is selected by user and then runs the macro. The macro then looks UP (B3, B2, B1 etc) cell by cell until it finds the first cell that has a valid date in it and if that date is same as the date that the macro is being run pastes "This Text" into the comments section (Not replacing everything in the comments but simply adding to it.)
Any help is very much appreciated!
~Tyler
