Hi all,
I'm fairly new to programming. I would be very happy if you can help me here.
I have a table with Coulmn A as start week and column B as end week and Column C:Column N as Jan, Feb, Mar,... Dec.
I want the vba code to check the value of start week and end week in the column A and Column B and merge the corresponding month columns.
For example,.If the value in the column A (start week) is 12 and value in Column B (End week) is 27, the vba code should merge the column having the month name from March to July.
In the attachment, I have shown the expected output for your reference.
Please let me know if I need to give further explaination.
Many thanks,
Regards,
puppy
Bookmarks