Hi All,
This is the requirement I have and it would be really helpful if someone can help me here.
1) Sheet1 in excel has 13 columns. I need to extract columns B,J and L to sheet 2.
2) Column B can be copied directly. But, column J is sort of like a history update and the matter would look somewhat like this:
2/8- blah1 blah1 blah1 blah1 2/7-blah blah2 blah2 2/6- blah3 blah3
3)I would need only the latest date and the text that follows it to be copied to next sheet. I also need to append something like "ABC says:-" after the date.
ie., in my sheet 2, I would have column B as 2/8- ABC says:- blah1 blah1 blah1 blah1
I'm a Beginner in macros and excel and any help would be greatly appreciated!!!
This is the requirement I have and it would be really helpful if someone can help me here.
1) Sheet1 in excel has 13 columns. I need to extract columns B,J and L to sheet 2.
2) Column B can be copied directly. But, column J is sort of like a history update and the matter would look somewhat like this:
2/8- blah1 blah1 blah1 blah1 2/7-blah blah2 blah2 2/6- blah3 blah3
3)I would need only the latest date and the text that follows it to be copied to next sheet. I also need to append something like "ABC says:-" after the date.
ie., in my sheet 2, I would have column B as 2/8- ABC says:- blah1 blah1 blah1 blah1
I'm a Beginner in macros and excel and any help would be greatly appreciated!!!