Variable column problem

S

shumonsaha

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Worksheet sorting code/technique advise 55
3 results possible on every day. add up the number of each on each day. 2
VBA to run all variable combinations in a calculation model and store result 6
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
convert columns to rows 6
NFL spreadsheet 3
how to get the resultsheet from the markslips 0

Top