Dear All,
I am attaching an excel with passenger details. I need the VBA code to fill the expected result column based on the cell value "Accommodation: Appartementen Nicholas (SKISNICH)" for each block of the bookings... This code will differ for each block of booking numbers... Hence we have to assign this code for each block based on the value available just before the 'Booking' cell [i.e. for first block ROW 7 to 17 = col J should be 'CHARSKIA' {this val avl in cell A6} || for second block ROW 24 to 26 = col J should be 'KLOSMARG'{this val avl in cell A23}, we have to continue until the end of last booking.]
I have attached the source file with the expected result highlighted in yellow colour.
Please help me for the vba code.
Thanks.
Bookmarks