http://www.box.net/shared/mv0e8fh87p

Hi. I have uploaded a sample data. First sheet is the "Original Data".
Second sheet is the formatted sheet where I recorded a macro. 3rd sheet is
the code of the macro and 4th sheet is a new sheet which is given to test the
macro.

Please refer Original sheet.

I have a problem with the macro. In the Original sheet, there are variable
columns after Col P

I have to delete some columns and connect Col R data (the TVR col) to Col I
(the duration column)

But in some sheets we have 3 TVR col and in some sheet more. Each TVR col
has to be connected to Duration. But in case I record a macro, its a problem
since it cannot recognize how many variable columns.

Need help