I have an excel file with info on hotels (column F) and rooms (CE)
this info need to be in the same line, all attached (no blanks). Hotel info on columns named check 1 to 76, room info on columns named prod 1 to 7
I have done lines 1 to 16 as an example, but I need all lines done (about 3000).
this would be a simple VBA script.