Converting multiple row data to single column data.

[nur2544]

Dear all.
Below macro is working fine for doing table data to column data.

Please Login or Register  to view this content.

As per macro above code “AS” is my last fixed Column. But the problem is some time i am to keep the data range till “P” column , some time I am having data till “X” column. So the column data range is not fixed.

I need to resolve this issue , where need to implement last column concept in the macro module .below is the full code.

Please Login or Register  to view this content.

[Mumps1]

try:

Please Login or Register  to view this content.

[nur2544]

Hi Mumps1 , Many thanks for helping me.

[Mumps1]

My pleasure.