danesrood
04-26-2009, 07:21 AM
Dear All
My first posting on this site so please appreciate that I am not that good with vba.
I have a need to look for repeated (quite numerous) occurrences of the months of the year and the text "YTD" that I receive from a main frame as text in the format mmm yyyy and then merge the cell that has the date/YTD in it with the two cells to the right.
The dates are not dates in the Excel way but merely text and every month is only 3 characters long plus the 4 digit year.
So to recap I have Apr 2008 in cell B4 with cells C4 & D4 blankand I want cells B4-D4 to be merged. In addition there will always be a YTD cell with two empty cells to the right that need to be merged.
I hope that I haven't made what I think is quite a simple problem sound to complicated.
Many thanks for any help that you can provide
My first posting on this site so please appreciate that I am not that good with vba.
I have a need to look for repeated (quite numerous) occurrences of the months of the year and the text "YTD" that I receive from a main frame as text in the format mmm yyyy and then merge the cell that has the date/YTD in it with the two cells to the right.
The dates are not dates in the Excel way but merely text and every month is only 3 characters long plus the 4 digit year.
So to recap I have Apr 2008 in cell B4 with cells C4 & D4 blankand I want cells B4-D4 to be merged. In addition there will always be a YTD cell with two empty cells to the right that need to be merged.
I hope that I haven't made what I think is quite a simple problem sound to complicated.
Many thanks for any help that you can provide